Topic: Logic with running totals Posted: 24 Oct 2011 at 5:20am
I have a running total field in the details section of my sub report and I wrote a logical formula using the running total. I use the logical formula to display the row in the section expert.
My problem is I need to display all rows where logic=1 plus the next row where my logic is =0.So if I have 10 rows in the section and the logic=1 in 5 rows I need to show the first 6 rows
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 24 Oct 2011 at 5:35am
if you are using an actual Running Total field (not just calling a custom formula a RT) then you you cannot use this logic with previous() or next() functions.
Instead you would have to alter your RT logic to handle what you want better or try to create a formula that replaces your RT.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 24 Oct 2011 at 6:19am
can you show some rows of what your data looks like and what you need to do with and the reason why (E.g. what is your logic for your 1/0 Runnnf Total creation)
Now let say that I have an order for 15, I want the report to show only the first 2 rows. What I did is I introdued RT and wrote a formula that if RT <=Order QTY then 1 else 0
My problem is that RT for row 2 is 20 so only row 1 shows and row 2 does not
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 24 Oct 2011 at 7:06am
so your "order for 15" is a numeric run time parameter?
and are you looking to show row 2 in this sample only because value is being reomved from it to get to the total order amount (e.g in your sample row one is <15)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
