Percentage Calculation in Calculation View

[Former Member]

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

[former_member228588]

Hi Ravi,

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

Thanks