I need a help in formula

Khadar

Country	State	District	Percentage Allocation	Values	Final Value
502364	520647	521987	0.2	3417
502364	520647	523378	0.123	3868
502364	520647	527298	0.5	2659
502364	520647	524982	0.02738	2413
502364	520647	522518	0.14962	2687
502364	502670	502672	0.235	3548
502364	502670	502674	0.635	3047
502364	502670	502679	0.13	2464
502364	521942	525960	0.123	2971
502364	521942	524941	0.14962	3215
502364	521942	527308	0.235	3939
502364	521942	526248	0.12837	3251
502364	521942	525869	0.36401	3083
502364	512135	512148	0.0947	3342
502364	512135	512158	0.748	2547
502364	512135	512187	0.0847	3032
502364	512135	512180	0.0726	3894

I need final value column to be calculated only when sum of percentages is equal to 1 for each state. As Each country is divided into states and into districts. The sum of percentage value is to be in equal to 1 for all districts when combined for state and it reverts for all country, and value is in Number and other are in text formats, can any one suggest with any idea to generate this condition

Dikshant

Try this out

Make sure State, Country and district are in list format

Khadar

Thanks for your help and support