Hi Guys ...
Here is the expression which give correct value only for 2017 Jan rest of the month are not correct
kindly help me on this.......
=num(((
(sum({<PCPM_Version_Desc = {'Adjustment','Actual'},PCPM_SalesType_Key={'1'},PCPM_SalesPeriod = {1},PCPM_Year=p(Year),PCPM_Month=p(Month),PCPM_Calendar_Month=p({<Calendar_Month={'<=$(=max(Calendar_Month))'}>}),PCPM_CP_Team_Flag={'CP','RPL','ORG'},PCPM_Day_Number_In_Month=p({<Day_Number_In_Month = {'<=$(=max(PCPM_Day_Number_In_Month))'}>}),PCPM_Day_of_Week=p({<Day_of_Week=>}),PCPM_RegionDesc={'*'},PCPM_AMHQCode=>}PCPM_Sales_Value))/1000
)
/
count({<PCPM_Month=p(Month),PCPM_Calendar_Month=p({<Calendar_Month={'<=$(=max(Calendar_Month))'}>}),PCPM_RegionDesc={'*'},PCPM_AMHQCode=>}DISTINCT (PCPM_FFName))
/
count({<PCPM_Month=p(Month),PCPM_Calendar_Month=p({<Calendar_Month={'<=$(=max(Calendar_Month))'}>}),PCPM_RegionDesc={'*'},PCPM_AMHQCode=>}DISTINCT (PCPM_Month))),'#,##0')
Regards
Hemanth
