Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear
Since we need a YTD as a date dimension in our business scope, we hope we can select it in a filter along with P1 to P12, so I created a Master Calendar. and I wrote a 'YTD' so as to select it in a filter.
Here comes the filter screenshot. If I select 'YTD' , Order Table can be selected by the right date. So far, it's alright.
But When I selected 'YTD', the Total OR Value is 0. I can't find where the wrong is?
This is my set analysis:
Sum({ <FROZENDATE= {"<=$(=max(FROZENDATE))"},FY={'CY'}>} ORVALUE)
Try this
Sum({ <FROZENDATE= {"<=$(=Date(Max(FROZENDATE), 'MM/DD/YYYY'))"},FY={'CY'}>} ORVALUE)