Help with Expression

[Anonymous]

Hi,

Not sure if this is possible; I am trying to create a conditional expression to sum the values based on the Product_Unit.

So if Product_Unit='CBM', sum CBMUnit, else sum OtherUnit.

Is this possible?

sum({$<Product_Unit={CBM}>} CMBUnit)

Product_Unit	CBMUnit	OtherUnit
CBM	5	0
CBM	5	0
KG	0	2
KG	0	2
KG	0	2

thanks

Derrell

[#2]

try this:

sum({$<Product_Unit={'CBM'}>} CMBUnit)

[Anonymous]

Sum(Pick(WildMatch(Product_Unit, 'CBM')+1, OtherUnit, CBMUnit))

[Anonymous]

Try this:(it happened for me and below worked)

=(if(Product_unit='CBM', Sum({<Product_unit={'CBM'}>} CBM_unit),Sum(Other_unit)))

This will work.

if not try this.

=(if(Product_unit='CBM', Sum({<Product_unit={'CBM'}>} Total <Product_unit> CBM_unit),Sum(Total <Product_unit> Other_unit)))

Hope this helps.

Regards,

Chinna

[jagan]

Hi,

Try like this using two Sum()

=Sum({<Product_Unit={'CBM'}>} CMBUnit) + Sum({<Product_Unit-={'CBM'}>} OtherUnit)

Note : The above expression is shown as syntax error near -=, but it works ignore that error.

Regards,

Jagan.

[jagan]

or you can just simply give

Sum(CBMUnit + OtherUnit)

because if Product_Unit=CBM you have the other Unit as 0 and vice versa.  So this also works.

Regards,

jagan.

[#7]

HI,

This should be work.

Sum(CBMUnit + OtherUnit)

Priyantha