KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to write a formula for a SSRS report. I am not for sure about the exact syntax, but it I am thinking it should be a nested iif but with multiple criteria, checking the value of the chart and division fields. At the end of the day if chart=110300 and division=100 then "Intercompany AP - USA" or if chart=110300 and division=200 then "Intercompany AP - RUS" other wise, then just display the chartname. Something like this but actually written correctly. iif Fields!chart.Value="110300" and Fields!division.Value="100" then Fields!chartname.Value="Intercompany AP - USA" if Fields!chart.Value="110300" and Fields!division.Value="200" then Fields!chartname.Value= "Intercompany AP - RUS" else Fields!chartname.Value I greatly appreciate any help on this!
Tags (comma-separated)
Save Edits
Cancel