Hi,
Am usin below formula,
IIF ({A.A_I} =0,0,convert(decimal(6,2),abs((({A.A_I})-abs({B.A_I}))/abs({A.A_I})*100)))
And get error "A number,currency,amount,boolean,date-time,or string is expected here" while 'convert' is highlighted.
Alternatively, Using Case as below:
(case {A.A_I} when '0' then '0' else convert(decimal(6,2),abs((({A.A_I})-abs({B.A_I}))/abs({A.A_I})*100)) end))
I get Error "The ) is missing" while 'case' is highlighted.
Thanks to help with any one of above formula's..whereas i need to calculate percentage...
IP Logged
