topic Re: TOTAL question in App Development

TOTAL question

ecabanas — Wed, 15 May 2019 11:03:37 GMT

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

Re: TOTAL question

Vegar — Wed, 15 May 2019 11:12:48 GMT

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))

Re: TOTAL question

ecabanas — Wed, 15 May 2019 11:19:39 GMT

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

Re: TOTAL question

sunny_talwar — Wed, 15 May 2019 11:41:12 GMT

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)

Re: TOTAL question

ecabanas — Wed, 15 May 2019 19:00:05 GMT

Great, nor it works

thank's @sunny_talwar

Re: TOTAL question

sunny_talwar — Thu, 16 May 2019 11:02:44 GMT

Glad I was able to help