How to restart 2 different running totals if a condition is met

[jhustonEFN]

Attempting to create a field "UploadNo" based on the running totals of two different fields that also must restart their counts when UploadNo changes.  

UploadNo increases by 1 if

If Running total>=1000 

or

Count>2

I can make a multi-row that updates one field but not all three.

Example:

Amount   Running Tot   Count  UploadNo

2,000       2,000             1            1

100             100             1            2

150             250             2            2

300             300             1            3

Thanks!

[IraWatt]

Hey @jhustonEFN,

Tool 3 multi row formula but this achieves what you were looking for:

Any questions or issues please ask :)
HTH!
Ira

[DataNath]

If you can make your UploadNo field as you say then you should just be able to use a ‘Running Total’ tool after the multi-row. Tick what running totals you want and then ‘group by’ UploadNo.