4 Replies Latest reply: Mar 29, 2018 9:58 AM by Jhonatan Ocampo

# Accumulative Values

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

• ###### Re: Accumulative Values

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

• ###### Re: Accumulative Values

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:

• ###### Re: Accumulative Values

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,

• ###### Re: Accumulative Values

Thank I just saw the app!!