conditional statement in graph expression

[laureadiaz]

Hello,

   I am trying to do get a margin but only if the price is >0 (we have some bad data)

I've tried a few things:

if(Sales_Price>0,
SUM(Sales_Unit_Price-Sales_Unit_Cost)/SUM(Sales_Unit_Price), 0)

Sum({<Quoted_Price={'>0'}>}),
Sum(Ave_Unit_Price-Ave_Unit_Cost)/SUM(Ave_Unit_Price))

Any Tips? I think I need Aggr in there maybe

Thanks!

[olivierrobin · Accepted solution]

hello

and what about

sum(if(Sales_Price>0,Sales_Unit_Price-Sales_Unit_Cost))/sum(if(Sales_Price>0,Sales_Unit_Price))

[laureadiaz]

This seems to do the trick thanks!