Division on Aggregation SUM in ABAP CDS

[nitinsaxena2608]

Hello Experts

I have a requirement where i am using default aggregation #SUM in ABAP CDS for two fields and displaying it in Fiori element Analytical page , i want to do the division on aggregate columns and create a new field from the division output ,but the division is not happening on Aggregation its happening row by row .

Any suggestion on this

[gasparerdelyi]

Is the ABAP CDS to be consumed only in analytical context?

Or consuming in non-analytical context is possible?

[karkrau]

@ gasparerdelyi

How would you solve this if you want to consume it in an analytical context?