Jan 6, 2008 #1 draacor IS-IT--Management Jul 17, 2007 69 US Is it possible to take a running total and divide it by another running total? and how would i be able to accomplish this?
Is it possible to take a running total and divide it by another running total? and how would i be able to accomplish this?
Jan 6, 2008 #2 lbass Technical User Feb 9, 2002 32,818 US Create a new formula in the field explorer: if {#yoursecondrunningtotal} <> 0 then {#yourfirstrunningtotal}/{#yoursecondrunningtotal} -LB Upvote 0 Downvote
Create a new formula in the field explorer: if {#yoursecondrunningtotal} <> 0 then {#yourfirstrunningtotal}/{#yoursecondrunningtotal} -LB
Jan 6, 2008 Thread starter #3 draacor IS-IT--Management Jul 17, 2007 69 US cool thanks, i found it for some reason i wasnt able to locate the running total formula to put it into my new formula. Upvote 0 Downvote
cool thanks, i found it for some reason i wasnt able to locate the running total formula to put it into my new formula.
Jan 6, 2008 #4 lbass Technical User Feb 9, 2002 32,818 US I am unclear whether you have this working now. -LB Upvote 0 Downvote
Jan 6, 2008 Thread starter #5 draacor IS-IT--Management Jul 17, 2007 69 US Ya i got it working, thanks. Sorry my last post was a little vague hehe Upvote 0 Downvote