topic Re: Running Total Calculation in Script Level in App Development

Running Total Calculation in Script Level

kirankumarsonoco — Wed, 12 Jan 2022 18:05:53 GMT

Hi Team,

I need to calculate the running total in script level, combination of Plant code and Item code, Please suggest to me ASAP, We have script like this,

Data:

LOAD
PLANT_CODE,
ITEM_CODE,
Key1,
DUE_DATE,
ITEM_DESCRIPTION,
ITEM_TYPE,
"Item Code Description",
"VENDOR_NUM" ,
"VENDOR_NAME",
"PO_NUMBER",
UOM,
COST,
day_key,
sum(ON_QTY) as ON_QTY,
DIM_TIME.REAL_DATE,
sum(EPO_QTY) as EPO_QTY,
sum(USAGE_QTY) as USAGE_QTY,
sum(Demand_QTY) as Demand_QTY
FROM [lib://DM_IPD_QVDs/Fact/Resin_Final_Master_Table.qvd]
(qvd)

group By
PLANT_CODE,
ITEM_CODE,
Key1,
DUE_DATE,
ITEM_DESCRIPTION,
ITEM_TYPE,
"Item Code Descriptio",
UOM,
COST,
day_key,
DIM_TIME.REAL_DATE,"VENDOR_NUM" ,
"VENDOR_NAME",
"PO_NUMBER";

Re: Running Total Calculation in Script Level

vikasmahajan — Thu, 13 Jan 2022 06:18:51 GMT

Data:

group By
PLANT_CODE,
ITEM_CODE;

Take Straight table & display fields dim : Plant_Code & Iteam Code

in expression sum(EPO_QTY) etc...

Hope this helps

Vikas

Re: Running Total Calculation in Script Level

kirankumarsonoco — Thu, 13 Jan 2022 06:39:42 GMT

Hi Vikas,

i need to achieve the running total in script level based on plant Code and Item Code

Re: Running Total Calculation in Script Level

vikasmahajan — Thu, 13 Jan 2022 09:21:42 GMT

Then join with this code

Right Join(Data)

LOAD

PLANT_CODE,
ITEM_CODE,

sum(EPO_QTY) as EPO_QTY,
sum(USAGE_QTY) as USAGE_QTY,
sum(Demand_QTY) as Demand_QTY

Resident Data Group By PLANT_CODE,ITEM_CODE Order By PLANT_CODE,ITEM_CODE ;

Re: Running Total Calculation in Script Level

kirankumarsonoco — Thu, 13 Jan 2022 13:20:33 GMT

but i need to calculate the running sum value in script level, you have, can we connect some time

Re: Running Total Calculation in Script Level

kirankumarsonoco — Mon, 17 Jan 2022 05:55:43 GMT

Please anyone suggest still this issue is not completed, i need to calculate the running total in script level based on Plant and Item code

Re: Running Total Calculation in Script Level

vikasmahajan — Mon, 17 Jan 2022 08:42:03 GMT

Sorry for late reply

Data:
LOAD * Inline [
Date,Plant, Item, Factor, Value
March,P1, NAM, 1, 50
March,P1, NAM, 3, 25
March,P1, NAM, 12, 10
March,P2, AFI, 5, 200
March,P2, AFI, 9, 100
March,P2, AFI, 1, 75
April,P3, NAM, 10, 500
April,P3, NAM, 11, 250
April,P3, NAM, 3, 150
April,P4, AFI, 8, 90
April,P4, AFI, 3, 30
April,P4, AFI, 1, 10
];

**bleep**:
NoConcatenate
LOAD Date,Plant,Item,Value,
if(Previous(Date)=Date and Previous(Item)=Item and Previous(Plant)=Plant , RangeSum(Value,Peek('Cummulative Sales')),Value) as [Cummulative Sales]
Resident Data
Order by Date,Plant,Item;

drop Table Data;

you can create script like this.

Vikas

Re: Running Total Calculation in Script Level

kirankumarsonoco — Mon, 17 Jan 2022 10:06:38 GMT

I have tried above script but still cumulative values are not coming, see below screenshot