Can decimal points be removed from a Chart, where the field formatting of the column being displayed is set to $1,234?

[BrownPaperBag]

I have a column displaying currency from a custom field, the field formatting is set to show integers with no decimal places, but on the chart the decimal places show-up and users have asked for these to be removed. Is this possible?

[JustinRenteria2]

This seems like a bug. I'd report it to Support.

[Sven-iX]

Hi @BrownPaperBag 
what shows up with decimals -  related to grouping? or the actual records? 

[BrownPaperBag]

Hi @Sven-iX 

the chart is showing the SUM of a currency field. 

In the details view, it shows:  

On the summary page, it shows: 

and finally, on the Chart page (bar chart in this instance), it shows: 

[Sven-iX]

Hi @BrownPaperBag 
Is there a grouping set for this report? 

[BrownPaperBag]

Hi @Sven-iX 

Yes there is, each of the values (as seen in the screenshots) represent a grouping of a custom field (single select) attached to a Project.

[Sven-iX · Accepted solution]

Man, I thought there'd be a way but: The chart makes an additional call to get chart data and in that call response it explicitly says "forcedecimals"

This is from the XML that is returned to draw the chart. So it looks like there's no UI way to suppress that ".00" 

Might make sense to create a ticket and argue that you've configured the column as integer to the chart should honor that.

[BrownPaperBag]

thank you for the additional investigation @Sven-iX  - I opened the network tab and saw something similar (decimal places = 2, or something to that tune) - I've raised a case with Adobe.

[ashgpt]

Hi Sven, 

I just checked this and would like to know if it is possible to get only whole numbers but no decimals in a currency number field on a custom form?
Number should be greater than 4 digits.

Example:

User enters - 100
Error message should display stating:
The minimum budget is $1000

Example:
users enters - 1000.50
Error message should display stating:
Please round to the nearest dollar.

Thank you in advance!

[Sven-iX]

Hi @ashgpt this should be it's own new question at doesn't relate to OP's issue about charts. 

on a currency field, click "Logic" and set up a "validation" 

IF(CONTAINS(".",{DE:Budget}),"Enter only round numbers", IF({DE:Budget}<1000,"Minimum budget is $1000"))

- this was a recent feature addition that is massively useful 

[ashgpt]

Wow, that's so prompt and has worked like a charm. You're a saviour Sven, thanks a ton! Cheers mate 🙂

[ashgpt]

Hello & Morning Sven, 

May I request for your help again please. I am stuck with the calculation here.

Current Expression:
IF(IN({DE:Primary Country}, "United Kingdom", "United States", "Global", "France", "Italy") ,"Yes","No")

Need to UPDATE to account for new logic:

If Primary Country = UK, Global, France, Italy = Yes
OR
If Primary Country = United States and {DE: Primary Brand} = Alpha, Beta = Yes

Otherwise
No

Thanks in Advance

[Sven-iX]

Hello @ashgpt 
What have you tried? 

[Sven-iX]

You will need to nest 2 IF statements

IF ( Condition 1 , 
     do smth if Cond1=true , 
     IF ( Condition 2 , 
          do smth if Cond2=true , 
          do something if neither is true 
     )
)