Hello Everyone,
I have a number field. I would like to display the value as whole number if the value is equal to or greater than 1 OR if its equal to 0. Otherwise, display as percentage with one decimal point. My current expression works for most values but it displays 0 as 0.0%. How can I add an (OR if loan_count = 0 then display whole number) statement to the IFF below?
=IFF(Fields!loan_count.Value>0.99,"NO","P1")
I really appreciate any input anyone has.
Thank you so much!