Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have several different dollar amounts in a field. I would like to only display the ones that are even amounts when no cents. How can I display only those values? I do not want to round the values, but only show those that do not have any values with cents. For example, $100, $200, $25, but not $100.01, $200.23, $25.25.
May be as attached:
Change the format of the result to a format without decimals.
For example:
num(expressionHere,'$ #,##0;$ -#,##0')
I first need to know how to get my results of just the even dollar amounts. I do not want to format the values. I just want to display only the even dollar amounts.
May be this:
If(Frac(Value) = 0, Value)
Have you tried the one I mentioned below?
I don't seem to be getting the proper results returned when using that. I know I have a lot more than what is being returned.
May be as attached:
Check Thirumala solution updated with my expression