Need help in Input box

[vikasshana]

Hi All,

Need your help in one of the requirement, I've created a variable and an input box where user can able to enter a value and can see the change in the straight table. Everything is working fine and the values are changing for the entire table but I want to see the change for a particular row rather than the whole table. Below are the examples.

Example -  This is what I'm getting.

input value is '10'.

Desc	Value	Result(Value+Input Value)
A	10	20
B	20	30
C	30	40

This is what I want to see in the straight table where the value has been changed for only the first row where Desc='A'.

Desc	Value	Result(Value+Input Value)
A	10	20
B	20	20
C	30	30

[RonaldDoes · Accepted solution]

Hi Bharath,

Would

=Sum(Value)+If(Desc='A', vSomeVariable,0)

work for you?

Please find the attached example.

Hope this helps you.

With kind regards,

Ronald

[pradosh_thakur]

may be something similar to this

if(Desc='A',Value+Input Value,Value)

regards

Pradosh

[vikasshana]

Thank you Ronald and Pradosh, I've modified the expression as below and is working fine.

=Count(Distinct Fieldname)+If(Desc='A', vSomeVariable,0).

Thanks again for your help guys.