if statement in text object properties

[nazaninslp]

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%'))

[sunny_talwar · Accepted solution]

Try this

Num(Sum({<PRICE = {'0'}>} USAGE_VOICE_H)/Sum({<PRICE = {'0'}>}VOICE), '#.0%')

[nazaninslp]

Thank you soooooooooo much

it is working fine now !