EXPRESSION WITH CONDITION IN SET ANALISYS

[inigoelv]

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,

[Gysbert_Wassenaar]

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))))

[jagan]

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))))