Cognos expression to SSRS

Question

I need some help with converting a Cognos expression into SSRS. Has anyone done it? I am brand new to reports

if [[ total[converted unit total] no.3 <>0] then [total[booked revenue]no.6/[total[converted unit total] n.3]]
else [0]


Can someone help me ?

---

FM

Answer 1

Hi Farhan,

You should use iif in ssrs, ex:

iif(sum(Fields!X.Value)<>0, sum(Fields!Y.Value)/sum(Fields!X.Value), 0)

Check more at: Expression Examples (Report Builder and SSRS)

Also: Operators in Expressions (Report Builder and SSRS)