0

Formula to constrain dates

Hello,

I didn't figured out how to contrain data from a sub-table on a print view so I'm trying a workaround…

how can I ad a date constraint (only September records for instances) to a formula field like: sum(Table1[Payd = 1].'Sub-total')?

Thanks

1 reply

null
    • Nick
    • 4 yrs ago
    • Reported - view

    Try like this (for September 2019):

    ---

    sum((select Table1 where Paid = 1 and Date >= date(2019, 9, 1) and Date <= date(2019, 9, 30)).'Sub-total')

    ---

Login to reply

Content aside

  • 4 yrs agoLast active
  • 1Replies
  • 853Views