TOTAL question

[ecabanas]

Hi

I'm using this expression to calculate the percentage of each item in total selection.

Sum (Revenues)
/
Sum (TOTAL<CalendarMonthName_C>(Revenues))

But I'm using in this expression and the results are that all items are 100%

Sum (unit_quantity * quantity_delivered)
/
Sum (TOTAL<CalendarMonthName_C>(unit_quantity * quantity_delivered))

Any idea what I'm doing wrong?

Thank's

[Vegar]

My best guess without beeing able to examine your application is that the issue lies in quantity_delivered.  Does the field reside inside the same table as unit_quantity? Is it an one-to-one relation between the row unit_quantity and the row quantity_delivered?

Do you get expected output when using

Sum (unit_quantity * quantity_delivered)

 And when using

Sum (TOTAL<CalendarMonthName_C>(unit_quantity * quantity_delivered))

[ecabanas]

Hi @Vegar 

Thank's for your reply, and no, the quantity_delivered comes from lines of revenues table and unit comes from the article database

best

Eduard

[sunny_talwar]

What is the expression for Weight Sold? Is it 

Sum (unit_quantity * quantity_delivered)

Do you see 1.991.581,00 repeated on all rows of the chart when you use this  

Sum (TOTAL<CalendarMonthName_C>(unit_quantity * quantity_delivered))

Alternatively, you can try this

Sum(unit_quantity * quantity_delivered)
/
Aggr(NODISTINCT Sum(unit_quantity * quantity_delivered), CalendarMonthName_C)

[ecabanas · Accepted solution]

Great, nor it works

thank's @sunny_talwar 

[sunny_talwar]

Glad I was able to help