Joined: 06 May 2011
Location: United States
Online Status: Offline
Posts: 3
Topic: use manual running total values in a formula Posted: 06 May 2011 at 5:15am
Hello,
I am trying to calculate a "percentage" based on 2 manual running total values. is there a way to make a formula use only the final total value of a MRT in a formula even though the value is based also on another MRT by group?
Joined: 27 Apr 2011
Location: United States
Online Status: Offline
Posts: 4
Posted: 06 May 2011 at 10:00am
I would use the sum function and put the MRT in a group or report footer. It will than create a feild that you can see in feild explorer and onse this field is there you create a new formula using this field. The key is you have to get the final total first then use that item as part of another formula.
Joined: 06 May 2011
Location: United States
Online Status: Offline
Posts: 3
Posted: 11 May 2011 at 8:17am
the problem is that the display formula for the one of the manual running total is not capturing the total sum fo that running total in the formula. I need to calcualte the percentage for a grouped record and the display formula is being calulated as the value of the running total when at that group.
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
