Forum Discussion
Multiple IFs with Limited Results
Hi,
I am needing to generate a report based on the types of system that we are selling.
In order to do this I need to do an IF on multiple fields but only return 5 different possibilites.
What I need is something along the lines of
IF staples, cliptrack, or trays return Screed
IF 16mm or 20mm return Overfloor
What is the best way to do this? The data is being pulled from the Dynamics 365 Database and is all based on True or False as they are just checkboxes within CRM.
Any advice is greatly appreciated.
Thanks
nickashwell Use SWITCH function. Something like this:
measure=
SWITCH(TRUE(),
[stables]||[cliptrack]||[trays],[screed],
[16mm]||[20mm],[overfloor]
)
1 Reply
nickashwell Use SWITCH function. Something like this:
measure=
SWITCH(TRUE(),
[stables]||[cliptrack]||[trays],[screed],
[16mm]||[20mm],[overfloor]
)