Skip to Content
0

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

Jul 16, 2017 at 07:38 PM

30

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers