I have a field which shows the total consumption like 159. I need to spread the numbers into 4 tiers
For EG:
Tier1: 10
Tier2: 30
Tier3: 60
Tier4: 59 (remaining numbers from Tier3)
Another EG:
Total Cons: 48
Tier1: 10
Tier2: 30
Tier3: 8
Tier4: 0
Any help how i can do this in ArcMap using VB script or Python?
See the example on using logic with Python: