Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

How to display only even dollar amounts in a Chart

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.

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

May be as attached:

View solution in original post

7 Replies
oknotsen
Master III
Master III

Change the format of the result to a format without decimals.

For example:

num(expressionHere,'$ #,##0;$ -#,##0')

May you live in interesting times!
cliff_clayman
Creator II
Creator II
Author

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.

sunny_talwar

May be this:

If(Frac(Value) = 0, Value)

sunny_talwar

Have you tried the one I mentioned below?

cliff_clayman
Creator II
Creator II
Author

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.

trdandamudi
Master II
Master II

May be as attached:

sunny_talwar

Check Thirumala‌ solution updated with my expression

Capture.PNG