Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
When I select March Month in List Box, the value is coming perfect for March month whereas select Apr month it is showing as wrong
Below is screenshot for your reference.
I want to see the value (130618) for match while selecting any months. Kindly please help me.
The correct value is 130618.
Expression:
(sum({$<Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Month={'*'},Calendar_Month = {'<=$(=max(Calendar_Month))'},Day_Number_In_Month = {'<=$(=max(Day_Number_In_Month))'},Day_of_Week=>}Sales_Value))/1000
Can you share a sample file to look into?