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