Using IIF Condition in SSRS 2005

• Aswanth

  SSChasing Mays

  Points: 608

  More actions

  February 29, 2008 at 3:25 am

  #187140

  I'm having the Following Table in SSRS 2005 Reports.....

  A B C Total

  2000 100 100

  1500 5000 150

  2340 100 1000

  1000 100 100

  Now I want the TOTAL in such a way that...

  If A < B, Then (A/1000)*C (the Value of C)

  If A > B, Then (B/1000)*C (the Value of C)

  How to Write this Field Expression Here...

  Please give me the Expression

  Thank You

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  February 29, 2008 at 7:07 am

  #783737

  =IIF(A.Value<B.Value,(A.Value/1000)*C.Value,C.Value)

  you can figure out the rest from here ... 😀

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg