How to add formula field to dynamic filter.

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

I have a "Date" field and a second formula field "Fiscal Period" that calculates the Fiscal Qtr & Yr from the "Date" field. How can I make this "Fiscal Period" a dynamic filter so that I can add to reports?

Photo of Priscilla

Priscilla

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Jesus

Jesus

  • 0 Points
There is no easy way to accomplish this as, for some reason, QB doesn't let you use formulas as dynamic filters. However if this formula field is called from another relationship it works.

The only way to accomplish this is by creating a relationship inside the same table. Basically relate Table A with Table A.

Here's a link to a similar question and hopefully it won't be confusing:

https://quickbase-community.intuit.com/questions/327400-how-do-i-designate-a-formula-text-field-as-a...