Access report totals for math operations

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
Does anyone have a technique to access report totals in order to perform math operations? I need to subtract one report total from another report total and display the result...both reports are on the same dashboard page.
Photo of MikeParks

MikeParks

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
After watching cartoons this morning I created this application to help answer your question:

Cogs and Sprokets
https://haversineconsulting.quickbase.com/db/bincxp95k

On the dashboard are sales summary reports for Cogswell Cosmic Cogs and Spacely Space Sprokets for years 2013 and 2014:

Cogswell's Cosmic Cogs Sales Summary $3,929,534 https://haversineconsulting.quickbase.com/db/bincxp96g?a=q&qid=5

Spacely Space Sprockets Sales Summary $4,223,591
https://haversineconsulting.quickbase.com/db/bincxp97g?a=q&qid=5

Yes I made up sales numbers into the future because we are dealing with the space age Jetsons. And I also wanted to force the vertical scroll bars to appear so I can show you how to get rid of them automatically.

I assume you want to do some type of math such as subtracting Cogswell's and Spacely's total Sales numbers and displaying the result. Can you confirm this is what you want to achieve?

I will show you how to do this in a variety of ways after I watch a run of Lost in Space episodes. I love that robot: https://www.youtube.com/watch?v=RG0ochx16Dg
Photo of MikeParks

MikeParks

  • 0 Points
LOL yes Dan that's exactly correct! I would like to add or subtract the two totals and display the result right on the dashboard...thanks!
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
Okay later tonight I will show you how to do this. It is easy to extract the information but you have to deal with reaching into the <iframe> from another <iframe>. I think I called this the Powerful Dashboard Technique in an earlier post:

https://quickbase-community.intuit.com/questions/786896-add-line-break-to-button#post-subnav
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
D> Okay later tonight I will show you how to do this

Sorry I was delayed but I had to prepare for Festivus (which is today):

The Story of Festivus
https://www.youtube.com/watch?v=c8g4Ztf7hIM

Festivus - The Holiday For the Rest of Us
https://www.youtube.com/watch?v=ma879--VKrI

The basic mechanics of how to do this is demonstrated in the following dashboard application and the essential code is listed in the Pastie Database:

Cogs and Sprokets
https://haversineconsulting.quickbase.com/db/bincxp95k

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=238

I try to make all my examples dead simple but I have to admit there are a lot of little things going on in this example. QuickBase has not designed their dashboards anticipating people would be doing things like this so there are a few small challenges to overcome. If you have questions on what everything does feel free to ask.

Happy Festivus Day To All.