Need help in Clear input box

[vikasshana]

Hi All,

I‘m using input box to input the value to change the records in the straight table and everything is working fine as required and I’m using button in order to clear the input box and is working fine as well. But the problem is when ever I click on button to clear the input box value the value in my straight table is changing as N/A. Instead of N/A I would like to see the original value.

Below example illustrates what I’m getting and what I’m expecting to see after clicking on clear button.

Example: Below is the Result which I‘m getting after clicking on clear button. Input value is ‘10’

Desc	Original Value	Result before clicking clear button  (Original Value + Input Value)	Result after clicking clear button
A	10	20	N/A
B	20	30	N/A
C	30	40	N/A

‌

Below is the result which I would like to see after clicking clear button to clear input values

Desc	Original Value	result before clicking clear	Result after clicking clear button
A	10	20	10
B	20	30	20
C	30	40	30

As you can see after clicking on the clear button it has to go back to it‘s Original value.

[pradosh_thakur]

Trh this

replace x with your variable

SUM(VALUE)+IF(ISNULL($(X))=-1,0,$(X))

[vikasshana]

Pradosh,

Do you want me to put the above expression into the clear button? Here value is nothing but 'Original Value'?

[pradosh_thakur]

no. i have changed the expression a litle

attaching  sample qvw. please set the button as per your requirement to clear the input box value.

[vikasshana]

Thanks for that Pradosh it's working fine and I've changed the button config, now I want only 'A' and 'B' to change to it's original value after clicking button. How to do that?

[pradosh_thakur]

what about C? Your requirement is not clear to me now. tell me the output.

[vikasshana]

The output will be something like this.

Input Value '10', after clicking on the button the 'C' value has to be 40 (Original Value + Input Value) but the 'A' and 'B' needs to change to it's Original Values (10 and 20)

Desc	Original Value	result before clicking clear	Result after clicking clear button
A	10	20	10
B	20	30	20
C	30	40	40

[pradosh_thakur]

hi stalwar1‌

a little help here.

regards

Pradosh

[sunny_talwar]

Check attached may be

[pradosh_thakur]

awesome!! You do have cheat codes for every problem .