Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Everyone ,
I am trying to run the following IF statement :
IF(EnCurrency='NIS',Num(sum( {$< TRANS_TYPE = {N}>} NIS_TRANS_TOTPRICE )* -1,
IF(EnCurrency='$',Num(sum( {$< TRANS_TYPE = {N}>} DOLLAR_TRANS_TOTPRICE )* -1,
IF(EnCurrency='EUR',Num(sum( {$< TRANS_TYPE = {N}>} CURRENCY_TRANS_TOTPRICE)* -1 )))) ;
EnCurrency= CURRENCY
for some reason this If statment doesn't
Hey Sangram Reddy ,
i took your advice and defined EnCurrency as dimension but didn't work....
Need more details than that if you want help on an error. how about a screen shot of the error your getting if any? Provide the context and people can help you out better.
Left a , in. This should work without an error
pick(match(EnCurrency,'NIS','$','EUR')
// NIS
, Num(sum( {$< TRANS_TYPE = {N}>} NIS_TRANS_TOTPRICE )* -1)
//
, Num(sum( {$< TRANS_TYPE = {N}>} DOLLAR_TRANS_TOTPRICE )* -1)
// EUR
, Num(sum( {$< TRANS_TYPE = {N}>} CURRENCY_TRANS_TOTPRICE)* -1)
)
Hi Jhonatan,
I tried plotting the dimension "EnCurrency" and the measure with the expression:
IF(EnCurrency='NIS', Sum( {$< TRANS_TYPE = {N}>} NIS_TRANS_TOTPRICE )* -1,
IF(EnCurrency='$', Sum( {$< TRANS_TYPE = {N}>} DOLLAR_TRANS_TOTPRICE )* -1,
IF(EnCurrency='EUR', Sum( {$< TRANS_TYPE = {N}>} CURRENCY_TRANS_TOTPRICE)* -1
)
)
)
Works absolutely fine!
Try using a bar chart to test the expression!