$ Amount

kim_barragan0126 · 2024-05-19T22:01:40+00:00

There was an error rendering this rich post.

I am using a Sales Funnel chart. When I have a dollar amount such as $12,363.12, the amount is omitted from the total. If I load it with just $12,363 it will show up. How can I still get a total with having the cents included? I have tried floating and fixed decimal both.

Find more posts tagged with

Accepted answers

GrantSmith

Because you have a $ in the data it's treating it as a string and can't do any mathematical operations on the data. Remove the $ from your data either in the source itself or using an ETL and convert it to a decimal number. You can then format this number as a currency in the card itself. This will allow you to do mathematical operations on the data.

All comments

GrantSmith

is your data formatted at just numbers and decimals or do you have the $ in your raw data?

kim_barragan0126

I have the $ in the data.

GrantSmith

kim_barragan0126

thanks!