Jump to content

calculating totals in portals


KneedHelp2

This topic is 6463 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I need to know how to calculate a total / subtotal of a revenue field summarized on the value of a second field. For example: Summarize total dollars based on blue, green, red orders. How can I make a running total field or script / report to gather this info? Can provide v8.5 sample file if necessary.

Link to comment
Share on other sites

This is very easy to do with a subsummary report. Make a new layout with a subsummary part and no body part. The subsummary part should be sorted on your orders (colors) field. Then, add a summary field that totals your orders/colors field and place it in the subsummary part. If you want a grand total, add a trailing grand summary part and place the same summary field in it as well. When you want to view the report, find the records you want, sort the database by the orders/colors field and then enter preview mode or print.

Link to comment
Share on other sites

This topic is 6463 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.