Click here to Skip to main content
15,884,176 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
HI,



In ssrs reports i need to ellaborate and evaluate the expression basing on the below conditions:



1. Modify the Comp Model Summary and Provider score card reports to show 100 % when the Patient Portal Enrollment(Measure 22) is > 100
2. Modify the Comp Model Summary and Provider score card reports to show 0 % when the Patient Portal Enrollment(Measure 22) is < 0


My expression is as follows:
=FormatPercent(Lookup(22, Fields!Measure_ID.Value, Fields!Target.Value, "Measures"),0)


Thanks & Regards,
Durga
Posted
Comments
Manas Bhardwaj 10-Nov-14 13:28pm    
and what's the problem?
OriginalGriff 10-Nov-14 14:06pm    
What have you tried?
Where are you stuck?
What help do you need?
dan!sh 10-Nov-14 18:53pm    
Unless someone knows the dataset and grouping set up of your report, it is very difficult to tell if the expression is correct.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900