Allow changes only in part of the rows in an input field

sonkumamon — Wed, 25 Nov 2020 16:16:04 GMT

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):

Is there any way to do so?

Thanks in advance.

Uri

Re: Allow changes only in part of the rows in an input field

Anil_Babu_Samineni — Tue, 25 Jul 2017 05:58:06 GMT

May be this?

If(Match(Dimension, 1,2,5,6), [Target Expression], [Target Expression])

Sum(Aggr(If(Match(Dimension, 1,2,5,6), [Target Expression], [Target Expression]), Dimension))