Skip to content

Instantly share code, notes, and snippets.

@ABooooo
Last active September 11, 2019 08:12
Show Gist options
  • Save ABooooo/b53733d2a7ecc8e4fec3b4d5395171df to your computer and use it in GitHub Desktop.
Save ABooooo/b53733d2a7ecc8e4fec3b4d5395171df to your computer and use it in GitHub Desktop.
=choose(Fields!Organisationlevel.Value, "Red", "Green", "Orange", "Blue")
if it is 1 then is red, if it is two then is green, if it is 3 is "orange", otherwise is blue
Video: Section 7, 56. Program Flow Functins
it can also be combined with iif
=iif(Fields!Organisationlevel.Value>3,"Blue",
choose(Fields!Organisationlevel.Value, "Red", "Green", "Orange"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment