Skip to Content
0

Percentage Calculation in Calculation View

Feb 06, 2017 at 04:16 PM

80

avatar image

Hi,

I was trying to achieve a simple percentage value after aggregation of 2 columns in CV. Strange tried many different ways but it is doing A/B at each row and adding up. I am aiming for sum(Col-A)/sum(Col-B). Any help to achieve this at HANA Calculation level is helpful.

It's strange that HANA doesn't parse SUM function in CV.

Thanks

Ravi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mrityunjay Pandey Feb 06, 2017 at 04:51 PM
1

Hi Ravi,

You can apply one more aggregation node in your calculation view to achieve this.

Thanks

Share
10 |10000 characters needed characters left characters exceeded