ISD_Aman Member

Hello Rob, I think the formulas are now working fine. Thank you for your assistance with how to get this to work. fixing the null's actually made the values appear. I am now experiencing issue with ETL Pivot, where its just pulling one row value rather than summing all the values of row that matches the Org code for rows.…

Tried it this way: (sum(`1500`) + sum(`1600`) + sum(`2000`) + sum(`2500`)) - (`8000`) and (`1500`+ `1600`+`2000`+`2500`)-(`8000`) Both coming back empty.

Hello Rob, I went ahead and created an ETL pivot, JL org key as row and the classes as columns. I then created a beast mode to sum and subtract the columns as needed. The beast mode is properly validated from formula perspective, but is not returning any results, just empty fields.

The formula needs to be based on the sum of the pivot columns. In the attached sample dataset: Columns A through e are dataset. Column H through N are pivot of the data, was able to do this using Pivot table chart.) Column P - Is the Collection total which is driven by formula ((Sum of net of class 1000+Sum of net of sum…

Hello RobSomers, Thanks for taking time. In this case statement the summing of the rest of the classes together for that job org is not accounted for. For Job org = a the correct formula would be (Sum of net of class 1000+Sum of net of sum of 1600+Sum of net of sum of 2000+Sum of net of sum of 2500 ) - sum of net of class…

That actually worked. Thanks.

That totally makes sense. I was able to correct it and now its working like Magic. Thank you.