Accumulate for the numerator, but regular for denominator

[#1]

How can I take the accumulation of one number and divide it by another number that is not accumulated?

Month     Sold     Inventory

Jan          5          10

Feb          4          20

Mar          6          15

April          3          15

So i wand to take the the Acculmated Inventory of of 60and divide it by the the April sold of 3 to get 20

Thanks in Advance

[Anonymous · Accepted solution]

Hi, you can add an expression with the formula: Rangesum(Above(Inventory, 0, RowNo())) and then a fourth expression with the formula: Column(3)/Sold.

Regards, Sander

[#3]

Thanks!!! That worked great!

[#4]

Hi Sander/James,

Can i get the complete script for this sample. How do you create a tablebox with the addditional columns for Calculations achieved. Please post the script used for acheiving it(I have only personal edition).

Thanks in Advance

Sri

[Anonymous]

Hi, create a straight table (not tablebox) with Month as dim and the others as expressions. Script is nothing more than an inline table.

Test:

LOAD * INLINE [

Month, Sold, Inventory

Jan, 5, 10

Feb, 4, 20

Mar, 6, 15

Apr, 3, 15

];

Regards, Sander

[#6]

Thanks Sanders,

One last question, how to remove the first row in the result which is not much useful. Attached the image.

Thanks,

Sri

[Anonymous]

Hi, on the expressions tab switch the total mode to no totals for each expression. Regards.