
Contributor III
2022-09-21
09:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RangeSum(Above
Hi experts
The following formula doesn't work or better the syntax is not correct. I need to calculate the value of the last 12 months as sum of the difference between Date1 and Date2:
RangeSum(Above({<[Status]={'Close'}, [Month],0 ,12>})[Date1] -[Date2])
Any ideas?
Thanks, tom
271 Views
0 Replies
