Forum

Notifications
Clear all

Reset sequence # when running total = 0

6 Posts
4 Users
0 Reactions
82 Views
(@kasey)
Posts: 20
Eminent Member
Topic starter
 

Hi

 

In attached I need to add 2 columns

Running total - contains an error value (why is it an error? as it is a simple formula)

Sequence - number to reset when Running total = 0

 

Many thanks

 
Posted : 24/02/2023 11:33 am
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

Hi Kasey,

Nothing attached.  Click Start Upload after selecting the file(s).

Phil

upload file

 
Posted : 24/02/2023 6:58 pm
(@kasey)
Posts: 20
Eminent Member
Topic starter
 

Ooops! Thanks Philip

 

Now attached 

 
Posted : 25/02/2023 8:42 am
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

The number -1.4210854715202E-14 is not an error. It's just a very very small number, very close to zero. Change the format of column F to Number with three decimals and you'll get 0.000 in F20.

 
Posted : 25/02/2023 9:42 am
(@kasey)
Posts: 20
Eminent Member
Topic starter
 

Hi

I am reposting this topic as I forgot to attached doc 

Please see attached

 

How do I add insert a formula (Sequence column) which will give the answers I have typed. The value will reset when running total = 0

 

Much appreciated.

 
Posted : 01/03/2023 6:41 am
(@bjarnehansen)
Posts: 3
Active Member
 

like this

 
Posted : 01/03/2023 9:20 am
Share: