Report Question: I do not want to show a number in a column if the number has a decimal point? (I only want to see whole numbers.)

Question

I am working with an assignment report, which includes a column for Strategic Rank.

Strategic Rank is a manually entered number in a custom field on the project. The format of the field is "number."

I added Column Rules to control which strategic rank numbers are shown, and the formatting: Column Settings > Advanced Options > Add Column Rule

If the strategic rank number is between 1-20, show the rank and turn the cell purple.
Don't show the strategic rank number if it is outside of that range (1-20).
I do not want to show the number if it has a decimal place (only want to show the whole numbers)

Please see the attached screenshot as an example.

Strategic Ranks with the green arrow are showing correctly (19, and the 'blank' rank was filtered out because it was outside of 1-20).
I do not want to see the 4.7 rank that has the red arrow pointing to it. (The tasks/assignments should still show on the report, but the Strategic Rank cell should be blank.)

I'm assuming I'll have to convert to text mode, but beyond that I'm not sure how to do this. Thanks in advance for any help that can be provided!

skyehansen · Accepted Answer

you could potentially just get away with doing something like this?

linkedname=direct
valueexpression=IF(CONTAINS(".",{DE:YourFieldNameHere}),"",{DE:YourFieldNameHere})
valueformat=customNumberAsString

(in other words, if the field name has a period in it, don't display it)

Sign up