I think the syntax needs to be different, if this is possible at all.
The 2nd part of the IIF is the ELSE statement where I would include another IIF statement instead of the OR condition. I'm not sure whether this would work.
In fact I would ask the customer to round by 3 significant digits.
If they round a result like 0.34 (3 significant digits) to 0.3, it appears as if the accuracy of the method is not better than 10%.
I will try this with the ELSE statement and the OR statement
Hello Marc, I came to that conclusion too this morning, thanks for the input. I will try to document that feature together with an example report.
BTW it does work in this way.
<posted by another person>
Sorry for the late reply but I think you can also accomplish the same using SWITCH as oppose to nested IIF.