675
Hi,in the pic below
In 5,division of the value in 2 and 3(Value of 2/Value of 3) is happening.When nothing is selected in 1(marked in the pic),no value is there in 2 and 3 and error pops up for the field(marked as 5 in the pic).
I want to eliminate this error.Please help!
First off, you should be referencing the properties of the controls, not just the controls in your formulas. DataCardValue24 and 20 are controls not values!
Failing to do so often leads to errors in the app when played for users.
Next, your formula should be changed to the following:
Share
Report
All responses (
Answers (
Round(IfError(Value(DataCardValue24.Text) / Value(DataCardValue20.Text), 0), 2)
That should eliminate your error message.
I hope this is helpful for you.
