if statement in expression

[stevietm]

Hi All

I need to work out an expression with the if statement I have checked the QV help and this is what I got so far   if(SEPExcl <'100',’sum((Quantity)/Size) * SEPExcl * 26/100)’,’sum((Quantity)/Size)*Percentage)’)

Every Time when I calculate this it returns the “sum((Quantity)/Size) * SEPExcl * 26/100)” expression and not the value can anyone please help??

Kind Regards Stevie

[SunilChauhan · Accepted solution]

if(SEPExcl <100,sum((Quantity)/Size) * SEPExcl * 26/100),sum((Quantity)/Size)*Percentage)))