How to Create a Report that Calculates Fees for each Month?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Our form contain the following fields: [Status] ,[Membership Fee], [Sign Up Date], [Billing Cycle] and [Cancellation Date].

We currently have a report that adds all Membership Fees if the Status = Active. This report only adds up all current membership fees though.

How would we generate a report that could add membership fees of each month? (Could we use our current fields to help generate that report)


An example of what we would want from our report:

Jan 2015 $3000

Feb 2015 $4000

March 2015 $2500

Photo of shoutoutlori

shoutoutlori

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Lovell

Lovell

  • 0 Points
Hello,  

I am Lovell and I am with QuickBase Care. Thank you for your question! You maybe able to accomplish this using a summary report or a table report with a calculated column. It's hard to say without seeing your app. In this case you may want to hit help in the upper left hand corner of your app and submit a support case for further assistance on this. 




Regards, 

Lovell

QuickBase Care