Problem with sum of numeric items
Posted: May 19th, 2023, 7:20 am
Hi experts!!
Hope you are well.
I need to enter sum of 6 numeric items/variables (B16,C3, C5,C7, C9, C14) in another (D1) item/variables. Enumerator will calculate sum using calculator and enter in 7th item/variable. I also applied logic that if wrong total is entered, error message should appear so correct value may be rented. For that logic is:
if D1 <> B16+C3+C5+C7+C9+C14 then
errmsg("total is not correct. rechecking is required for B16,C3, C5,C7, C9, C14");
reenter;
endif;
Entering value in 6 items/variables are also subject to applicability depending upon other question, thus, i also applied skip logics that working properly. However issue is if one or more items/variables skip, the error message (total is not correct. rechecking is required for B16,C3, C5,C7, C9, C14) always appear while entering sum in 7th item/variable and it stocks. In case value is entered against all 6 items/variables, D1 works fine.
Kindly can you please identify what is issue and solution. Thanks!!
Hope you are well.
I need to enter sum of 6 numeric items/variables (B16,C3, C5,C7, C9, C14) in another (D1) item/variables. Enumerator will calculate sum using calculator and enter in 7th item/variable. I also applied logic that if wrong total is entered, error message should appear so correct value may be rented. For that logic is:
if D1 <> B16+C3+C5+C7+C9+C14 then
errmsg("total is not correct. rechecking is required for B16,C3, C5,C7, C9, C14");
reenter;
endif;
Entering value in 6 items/variables are also subject to applicability depending upon other question, thus, i also applied skip logics that working properly. However issue is if one or more items/variables skip, the error message (total is not correct. rechecking is required for B16,C3, C5,C7, C9, C14) always appear while entering sum in 7th item/variable and it stocks. In case value is entered against all 6 items/variables, D1 works fine.
Kindly can you please identify what is issue and solution. Thanks!!