$ Amount

kim_barragan0126

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.

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.

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

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.

kim_barragan0126

thanks!