Skip to Content

Analytical View calculated column to show percentage division of decimal(15,2)

Hello,

In an analytical view I am trying to display % as a calculated column. Formula is

(tax_amount / gross_amount)*100

tax and gross amounts are of Decimal(15,2) data type. No matter which data type I choose for the calculated column it always throws error in data preview

I have tried casting the amount fields but to no avail. Please suggest how to solve this. I do not need to perform anymore calculations or aggregation on Percentage column so it is an attribute and not measure.

Thanks,

Anubhav

error.jpg (40.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers