Log In
Register
Home
See Answer
October 5, 2010
Offline
Answers Post
New Member
June 2, 2021
Offline
I've seen it but it doesn't work, you can check the file
Column(G)=IF(E3>0,F3,SUM(N(+G$2:G2)))
October 5, 2010
Offline
If you actually try to provide detail about what it is and explain clearly the result you want, it'll be much easier to help you.
To start, in your workbook (and in your previous reply) you have an Excel formula. This isn't M code, so I'm not clear on whether you want a Power Query solution, or to use an Excel formula.
Secondly, I can't see what is wrong. Your formula is doing what it is written to do. How exactly does the result it gives differ from what you want.
Thirdly, if you have seen the posts on running totals in Power Query (which do work) and tried the code, you haven't explained why they don't produce the result you are after.
Regards
Phil
Trusted Members
Moderators
November 1, 2018
Offline
Also cross-posted here: https://chandoo.org/forum/thre.....ery.52167/
The following users say thank you to Velouria for this useful post:
Philip Treacy
1 Guest(s)
