topic Re: Accumulative Values in App Development

Accumulative Values

jhona1737 — Thu, 29 Mar 2018 12:39:42 GMT

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

petter — Thu, 29 Mar 2018 12:56:24 GMT

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

Re: Accumulative Values

petter — Thu, 29 Mar 2018 13:22:09 GMT

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

jhona1737 — Thu, 29 Mar 2018 13:55:07 GMT

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

jhona1737 — Thu, 29 Mar 2018 13:58:39 GMT

Thank I just saw the app!!