Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using straight table and I have a problem with calculation "Total Qty" - the formula should be sum(Qty) grouped by Code.
Can anyone help me with set analysis formula?
Code | Sub code | Qty | Total Qty |
---|---|---|---|
111 | a | 25 | 58 |
111 | b | 23 | 58 |
111 | c | 10 | 58 |
222 | a | 11 | 68 |
222 | b | 34 | 68 |
333 | c | 23 | 68 |
See this sample may be it help you!!
Hi,
i don't know what you expect result. i thought you need total qty in all rows.
use this for total qty for each row
Ex: Sum(TOTAL [Total Qty])
Try sum(total <Code> Qty)
Try this
aggr(sum(Total Qty),Code)
try this
Aggr(sum([Total Qty]),Code)