Auto Calculation

Support
1

Hi All,
Am working for Household forms.
where i have crops for three seasons.
each season having 4 - 5 crops.
Based on selection of crops from each season i need to calculate Total Agriculture Income .
I have attached sheet how i proceeded.But am not able to calculate total if only one / two crop selected from each season.
Help me out at earliest.

Thanks in Advance.

Book1.xlsx (16.0 KB)

2

Hi @mallikapandu,

1- Your post should be in Support instead of Development.
2- Fast checking: Perhaps your calculation needs a coalesce function to consider cases where there is no data (not selected). Check this post with similar case

3

Thank you for your reply.I have tried with if statement its working .
I will check with coalesce function also.

Thank you once again@Alexander_Torrado