locked
PowerView - Data Management RRS feed

  • Question

  • I am trying to create a field called Level based on Total Actual Sales.  If Total Actual Sales is a certain number, I want to display text in the new field called Level.  My syntax is correct, but the field does not display as an option to pull on to my canvas in Power View.  

    Level:=IF([Total Actual Sale]>=650,"Yellow",IF([Total Actual Sale]>=1250,"Green",IF([Total Actual Sale]>=2000,"Blue","Red")))

    Friday, June 12, 2015 2:37 PM

All replies

  • As i know, SSRS don't  know if function it has iif function. Is SSRS don't throw you this exception?
    Monday, June 15, 2015 11:14 AM