Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help with hopefully is a simple problem.
I've attached a simplified image belowof the problem I'm having.
I want my total from the first row to then be to the Start Qty of row 2 then the total for row 2 to be the Start Qty for row 3 and so on.
I'm grouping by Start Date & Material #
Hi,
Here is the solution.
Data:
LOAD Date(Date#(StartDate,'DD/MM/YYYY')) as StartDate,Material,StartQty,BuildPlan Inline [
StartDate,Material,StartQty,BuildPlan
14/07/2017,ABC,200,20
15/07/2017,ABC,200,40
16/07/2017,ABC,200,50
17/07/2017,ABC,200,30
];
Final:
Load StartDate as StartDate1 ,Material as Material1,BuildPlan as BuildPlan1,
If(RowNo() = 1,StartQty,Peek(Total)) as StartQty1,
If(RowNo() = 1,StartQty-BuildPlan,Peek(Total)-BuildPlan) as Total
Resident Data order by StartDate ASC;
Regards,
Kaushik Solanki
Is this exactly how your data is? or are you evaluating QTY and build plan in the straight table?
Please post a sample app