Skip to main content
Question

Year-Month Reference Field

  • March 10, 2021
  • 0 replies
  • 123 views

I have a table called Orders.  Fields include Creation Date (YYYY-MM-DD), Total Revenue, and Total Refunded for each customer's order.  I need to create a new table to sum the Total Revenue and Total Refunded by Year-Month Combo.  I'm doing this so I can figure out the Average Refunds per Month (which I apparently can't do using a Summary Table on the Orders table).

I'm stuck trying to figure out how to create a field on the Orders table that is just the Year-Month Combo (date field?  text field?) that I can then use as the reference field on the parent Year-Month Table (can I use a formula field as a reference field?).  

Thanks for any clarity you can provide.

------------------------------
Kevin BP
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Can you tell us more about that field [YYYY-MM-DD] what field type is it and it it is a formula field what is the formula.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------