cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member184111
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (0)