SSRS Format

I have a question on Conditional Format. I have 2 fields
=Fields!Cost.Value
=Fields!OrderCost.Value


I want to make a new dataset or a textbox that displays the greater of the 2 which is the easies way to do it?
gotti777Asked:
Who is Participating?
 
HadushConnect With a Mentor Commented:
You can just use expression  
Note: How would like to handle them if they are both equal?


=IIF (Fields!Cost.Value>Fields!OrderCost.Value, Fields!Cost.Value, Fields!OrderCost.Value)

Open in new window

0
 
gotti777Author Commented:
display ordercost .. i guess it dont matter snice there the same
0
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
If you just want the greatest value, irregardless of which field it came from, then the code Hadush provided will work.  I ran some test to make sure nulls would not cause any deviations and between 2 numeric fields, it works fine.
0
All Courses

From novice to tech pro — start learning today.