Skip to Content
avatar image
Former Member

Percentage Calculation in Calculation View

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 06, 2017 at 04:51 PM

    Hi Ravi,

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

    Thanks

    Add comment
    10|10000 characters needed characters exceeded