on 07-16-2017 8:38 PM
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
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.