Forum Discussion
Solved
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...
nickashwell Use SWITCH function. Something like this:
measure=
SWITCH(TRUE(),
[stables]||[cliptrack]||[trays],[screed],
[16mm]||[20mm],[overfloor]
)
nickashwell Use SWITCH function. Something like this:
measure=
SWITCH(TRUE(),
[stables]||[cliptrack]||[trays],[screed],
[16mm]||[20mm],[overfloor]
)