Percent check in Rosters

[Habtamu]

Dear Cspro Teams
I need help percentage calculations on rosters form. Iam working on the agricultural survey with the variables Parcel number, Field number, Field type (single crop, Mixed crop and Other Land).

So, if the field type is single crop and other land the percentage is 100 coverage on the field because only single crop will be cultivated on the plot but if the field type is mixed two or more will cultivated on the field area, so I need a function to calculate the total percentage to be 100 for all crops shared in a single field.

For your reference here I attached the document.

[khurshid.arshad]

Please see attached file.
a.

[Habtamu]

Thank You khurshid.arshad for you quick response

[Habtamu]

Thank you khurshid.arshad for quick response, for a single crop no problem it is 100 that I can impute it, the challenged one is if it is mixed crop on the same plot the sum percentage of the crops on field should be 100 if two or more crops on the same plot.

For Example

If the field type is mixed crop on the plot or the field with three crops. Crop1 =20%. Crop2 =50%, Crop3 id wrongly entered=50% the total percentage is 120% that is wrong, the percentage is not below 100 or above 100, we have to correct one of them from three. I need to check consistent error message from this case.

Thank you for your support.

[khurshid.arshad]

Would you like the calculation as detailed in the attached file?
a.

[Habtamu]

Yes, khurshid.arshad that is What I want. I appreciate you for your help

[khurshid.arshad]

Please see attached files.
a.

[Habtamu]

Thank you very much khurshid.arshad, you solve my point on my questions. Iam following your YouTube video it is very helpful.