Auto mathematical calculations using numeric items
Posted: June 14th, 2023, 5:26 am
Hi Experts,
I need help for following three scenarios around numeric items B12, B18 and B19. Can you please help in providing logic text or some leads in this regard.
1. For B19 the value should auto fill/appear that would be actually answer of B12 divided by B18. Value in B19 decimals is also a possibility.
• answer in B12 =100, to be entered by enumerator
• answer in B18 = 7, to be entered by enumerator
• answer in B19 = 100/7=14.29, auto filled/appeared and may not be edited
2. For B19 the value should auto fill/appear that would be actually answer of B12 plus B18.
• answer in B12 =100, to be entered by enumerator
• answer in B18 = 7, to be entered by enumerator
• answer in B19 = 100+7=107, auto filled/appeared and may not be edited
3. For B19 the value should auto fill/appear that would be actually answer of B12 minus B18.
• answer in B12 =100, to be entered by enumerator
• answer in B18 = 7, to be entered by enumerator
• answer in B19 = 100-7 =107, auto filled/appeared and may not be edited
regards
I need help for following three scenarios around numeric items B12, B18 and B19. Can you please help in providing logic text or some leads in this regard.
1. For B19 the value should auto fill/appear that would be actually answer of B12 divided by B18. Value in B19 decimals is also a possibility.
• answer in B12 =100, to be entered by enumerator
• answer in B18 = 7, to be entered by enumerator
• answer in B19 = 100/7=14.29, auto filled/appeared and may not be edited
2. For B19 the value should auto fill/appear that would be actually answer of B12 plus B18.
• answer in B12 =100, to be entered by enumerator
• answer in B18 = 7, to be entered by enumerator
• answer in B19 = 100+7=107, auto filled/appeared and may not be edited
3. For B19 the value should auto fill/appear that would be actually answer of B12 minus B18.
• answer in B12 =100, to be entered by enumerator
• answer in B18 = 7, to be entered by enumerator
• answer in B19 = 100-7 =107, auto filled/appeared and may not be edited
regards