Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody:
I need help to include one condition into a set analysys.
I have one expression that shows only one value:
Min(Total <Description> fabs([€/Ton]*(1+Merma/100)*Aggr((Gramaje)-Avg([Grammage calculado (gr/m2)]),Description,Paper)))
and I would like to include into this expression like a filter in this expression:
MinRM=Min([€/Ton]*(1+Merma/100))
Is it possible?
Thanks in advance
Best regards,
Maybe like this:
If(MinRM=Min([€/Ton]*(1+Merma/100)),Min(Total <Description> fabs([€/Ton]*(1+Merma/100)*Aggr((Gramaje)- Avg([Grammage calculado (gr/m2)]),Description,Paper))))
Hi,
Try like this
If(MinRM=Min([€/Ton]*(1+Merma/100)), Min(Total <Description> fabs([€/Ton]*(1+Merma/100)*Aggr((Gramaje)-Avg([Grammage calculado (gr/m2)]),Description,Paper))))