Division and Percentage calculation in HANA views

[Former Member]

Hi Experts,

We are trying perform division and percentage calculations in HANA

calculation views and facing these issues.

1. If we calculate division(A/B) then it's doing division for all the

lines and its summed up in the report. The expectation is the division

after aggregation of column A & B.

2. If we calculate the percentage calculation then the each line is

calculated percentage and summed up in the report.

Please provide the suggestion to get this calculation done.

[vairma]

Hi Seenivasan,

Can you let me know, how you have achieved the above logic in Calculation view?

Regarding 1 point : If you are using graphical calculation view, then you can use first aggregation node, the calculate division using the calculated column.[Refer screen shot attached (Graphical1)]

Regarding 2 point : If you are using graphical calculation view, then you can calculate percentage using calculated column, then use aggregation node.

[Refer screen shot attached (Graphical2)]

Hope this Helps

Best Regards,

Vaibhav