Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears
I want to show usage amount in text object and it contains if statement too, but when I run below ode , it just show a plain dash(-) like below :
IF(PRICE='0',NUM(sum(USAGE_VOICE_H)/sum(VOICE),'#.0%'))
I read lots of samples about this issue and changed my query to below one, but now the amount is wrong, it should be 7.3%.
would you please help me?
=sum(IF(PRICE='0',num((USAGE_VOICE_H)/(VOICE)),'#.0%'))
Try this
Num(Sum({<PRICE = {'0'}>} USAGE_VOICE_H)/Sum({<PRICE = {'0'}>}VOICE), '#.0%')
Try this
Num(Sum({<PRICE = {'0'}>} USAGE_VOICE_H)/Sum({<PRICE = {'0'}>}VOICE), '#.0%')
Thank you soooooooooo much
it is working fine now !