Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone.
I need to allow changes in only parts of the rows in an input field.
For example, Actual is the input field, and I want to allow the user to change only the cells in yellow
(Since dimension 4 and 7 are the sum of their previous 2 rows):
Dimension | Actual | Target |
---|---|---|
1 | 36 | 40 |
2 | 18 | 15 |
3 | 769,540 | 1,000,000 |
4 | 54 | 45 |
5 | 5 | 4 |
6 | 2 | 3 |
7 | 7 | 7 |
Is there any way to do so?
Thanks in advance.
Uri
May be this?
If(Match(Dimension, 1,2,5,6), [Target Expression], [Target Expression])
OR
Sum(Aggr(If(Match(Dimension, 1,2,5,6), [Target Expression], [Target Expression]), Dimension))