Hello Together,
I need yout help again for a Problem.
I would like aggregar the Value from Part A to Part B, show like this:
Part |
Original_Value
|
Shifted_Value |
Total_Shift |
A |
15 |
0 |
15 |
B |
23 |
15 |
38 |
My idea for the solve (Total_Shift) was:
if(Part = B,
sum({<Part={'A'}>}Original_Value) + sum(Orginal_Value),
sum(Orginal_Value)
)
And for the Shifted_Value I tried:
if(Part = B,
sum({<Part={'A'}>}Original_Value),
0
)
But I get only for the Part A the Values, not the other One.
Best Regards
Merry