Accumulative Values

[jhona1737]

Hi All, I been trying to accumulative values in a horizontal table, I was able to create on a vertical one using this variables:

SET [accum] ="RangeSum(Above(";

SET [/accum]=",0,rowNo(TOTAL)))";

I am trying to keep track of inventory.

Thank you all

[petter]

Could you share how your expression looks like for the measures you have?

[petter · Accepted solution]

First of all you have to change your Above() function to a Before() function since you have pivoted the data. You might have to change other things too if you have a different data model than I have tried to guess at...

You can have a look at how it works in the app I quickly made where it works well:

[jhona1737]

Hi Petter,

That's great thank you, this was the expression I used for the table:

$(accum)sum({<[Item Category Code]={'TILAPIA'}>}MonthlyInventoryLBS) $(/accum)+

($(accum) sum({<[Item Category Code]={'TILAPIA'}>}Total_Po_Qty_Lbs) $(/accum)+

$(accum) sum({<[Item Category Code]={'TILAPIA'}>}PIQtyBase) $(/accum))-

($(accum) sum({<[Item Category Code]={'TILAPIA'}>}BaseUnitSOQTY) $(/accum)+

$(accum) sum({<[Item Category Code]={'TILAPIA'}>}BaseQTYInvocie) $(/accum))

but is does not give the total balance as you table could you please show the expression that you used for both types of tables.

Thank you,

[jhona1737]

Thank I just saw the app!!