Example of one of our reports. We want to show this 0 as <1000.

Please show us your IIF function so we can see where you may be going wrong.

IIf([PI2]>0,[PI2]*1000,0)

I had to put the 0 there because it kept giving me a syntax error. But I want the 0 to be a <1000.

X: IIf([P12]>0,[P12],"<1000")

It worked!!!! Thank you!

Hello!
Thank you for all your help earlier. I have 2 additional questions.
1: My expression works but I've now lost the commas for the numbers. Is it possible to fix this?
2: My boss now wants me to have it show the H2O Dilution as <1. So, my question is it possible to add a 2nd IIF expression 1 for the H2O as <1 and everything else as <1000? Or do I need to separate the H2O from the rest of the results and give it its own IFF expression?
Here is my current Exp in my query.

P: IIf([PI]>0,[PI]*1000,"<1000")

Thank you for any assistance you can provide.

1. Use the Format function on the result.
2. Sure. Just use nested IIF functions.

I cover both of these things in a couple of different videos, but I'm on the road right now so I can't search for the links for you - but use the search bar up top.