Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,Can anyone pls suggest why my below expression is wrong:
sum( if(ACCT='QOP.C' or 'MHOODC' ,{<status={Current}>} Sold_At*Qty*CONV_RATE,
{<status={Current}>} Sold_At*Qty))
Thanks,
Swetha
You can try:
sum({<status={'Current'}>} if(ACCT='QOP.C' or ACCT='MHOODC' , Sold_At*Qty*CONV_RATE,
Sold_At*Qty))
I got it,Thanks!
You can try:
sum({<status={'Current'}>} if(ACCT='QOP.C' or ACCT='MHOODC' , Sold_At*Qty*CONV_RATE,
Sold_At*Qty))
Yep Yep tried the same and got it.Thanks!