Master Item over set date ranges

[akraman]

Hi all,

I am looking to have a Master Item that takes two fields [Revenue]/[Business Days], calculated over a two sets of date ranges.  My idea was to create four variables (vStartdateA, vEndDateA, vStartDateB, vStartDateB) and have a separate master item that covers these date ranges and the calulation master item but I am unclear on the correct syntax or approach. I tried variations of this without success: SUM({<SaleDate={'>=$(vStartDateA)','<=$(vEndDateA)'}>}[Daily Run Rate])

[MatheusC]

@akraman 
Try adjusting your syntax in set analysis:

SUM({<SaleDate={">=$(vStartDateA)<=$(vEndDateA)"}>}[Daily Run Rate])

- Matheus