SSRS Report

[RedTdot]

THIS IS THAT IS USED IN CRYSTAL REPORT AND I WANT TO  USE IT IN SSRS EXRESSION OR PAGINATED REPORT

{Allotment_Details.DIST_TYPE} &
(if isnull ({Allotment_Details.ALLOT_PCT}) then '' else
' ('&totext({Allotment_Details.ALLOT_PCT},2)&'%)')

LOOKING TO CONVERTED TO SSRS EXPRESSION

[v-jingzhang · Accepted solution]

Hi @RedTdot 

Users in Power BI community may have no experience in CRYSTAL REPORT, so they may have difficulty understanding what this formula does. Can you use some examples to explain what you want to get?

If I understand it correctly, perhaps you can try

=Fields!DIST_TYPE.Value & IIF(IsNothing(Fields!ALLOT_PCT.Value),"","("&Format(Fields!ALLOT_PCT.Value, "F2")&"%)")

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.