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
-
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')
---
Content aside
- 5 yrs agoLast active
- 1Replies
- 854Views