Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
my goal is to not include calculations for 0 or null values in the Planned column so that they won't be added in the (Act - Plan) column.
This needs to be row-based.
I cannot do this in the load script because the data comes from different tables.
Material | Actual | Planned | (Act - Plan) |
---|---|---|---|
Total | 10 | 4 | 4 |
A | 8 | 4 | 4 |
B | 2 | 0 | 0 |
So the question is how to do this row-based calculation?
Thank you for your Input.
=if(Plan>0,Act-Plan,0)
like below !
=if(Planned>0,Actual-Planned,0)
Ok, I do understand my own problem better now 🙂
In my calculation I use sum functions for all three calculations. When I use above formulas I get the right calculation for each row but the total field is 0.
I tried different modifications of the formula but all resulted in a total value of 0.
For example:
=if(Planned>0,sum(Actual)- sum(Planned),0)
Is tere a way to fix this?
Go to expression > Total > select the Row>total option that should help you to get the Total
please post a sample app
Preparing examples for Upload - Reduction and Data Scrambling
You are right, it works for a straight table to set the Total Mode to "Sum".
Is there a way to do this for a Pivot table as well?
Hi,
May be as in attached file
Regards,
Andrey
Did you tried with the partial sum option in the presentation tab ?