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.
Change the format of the result to a format without decimals.
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.