I am after some expert help if possible. I am trying to write a sum in set analysis that allows me to filter my data between 2 date variables. I have been able to get the set analysis to work using hard coded dates but i need to use a variable to remove the manual intervention once my app is live.
Thank you for your reply Taoufig_Zarra. I have tried your method and it did not seem to work. Maybe a better approach would be....does anyone else have a working example that I could analyse to try and pick up any variations?
just to add! there was a >} added after the date variable part, removing this and the calculation works but for the full year, like it is not reading the month section of the calc?