Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ,
I am writing the below Expression in Text box. when I select Particular month ,It is giving Correct value .I need the Same value Without Selecting Max month.
My requirement is by default it should show Max Month value.
=Num(Avg(Aggr((((Count({<Attr_Flag = {1}, Cal_Year={'$(vMax_Year)'}, Cal_Month=, Cal_Quarter=, Cal_Date={"<=$(=Max({$<Cal_Year={'$(vMax_Year)'}>}Cal_Date))"} >}Distinct [Employee Code])/
((Count({$<Cal_Month_Flag={1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Active Flag DayWise]={1}>}DISTINCT [Employee Code])+$(vTest))/2))/
Count({$<Cal_Year={'$(vMax_Year)'}, Cal_Month=, Cal_Quarter=, [Cal_Month ID]={"<=$(=Max([Cal_Month ID]))"}>}DISTINCT [Cal_Month ID]))*12),Cal_Month)),'#0.00%')
Any Suggestions would be greatly Appreciated.
Regards,
Divya
try tis,
=Num(Avg(Aggr((((Count({<Attr_Flag = {1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, Cal_Date={"<=$(=Max({$<Cal_Year={'$(vMax_Year)'}>}Cal_Date))"} >}Distinct [Employee Code])/
((Count({$<Cal_Month_Flag={1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Active Flag DayWise]={1}>}DISTINCT [Employee Code])+$(vTest))/2))/
Count({$<Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Cal_Month ID]={"<=$(=Max([Cal_Month ID]))"}>}DISTINCT [Cal_Month ID]))*12),Cal_Month)),'#0.00%')
Hi,
Try this,
=Num(Avg(Aggr((((Count({1}{<Attr_Flag = {1}, Cal_Year={'$(vMax_Year)'}, Cal_Month=, Cal_Quarter=,
Cal_Date={"<=$(=Max({$<Cal_Year={'$(vMax_Year)'}>}Cal_Date))"} >}Distinct [Employee Code])/
((Count({1}{$<Cal_Month_Flag={1}, Cal_Year={'$(vMax_Year)'},
Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Active Flag DayWise]={1}>}DISTINCT [Employee Code])+$(vTest))/2))/
Count({1}{$<Cal_Year={'$(vMax_Year)'},
Cal_Month=, Cal_Quarter=, [Cal_Month ID]={"<=$(=Max([Cal_Month ID]))"}>}DISTINCT [Cal_Month ID]))*12),Cal_Month)),'#0.00%')
Hi Divya,
Try to add = before all the variables and check once, if still facing same issue please post the app
Try to use ALL function like -
Max(ALL [Dimension])
Hope this helps.
Hi,
Thanks for the response, Still getting the same issue.
Can you post the sample data?
can you please share qvw..
try tis,
=Num(Avg(Aggr((((Count({<Attr_Flag = {1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, Cal_Date={"<=$(=Max({$<Cal_Year={'$(vMax_Year)'}>}Cal_Date))"} >}Distinct [Employee Code])/
((Count({$<Cal_Month_Flag={1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Active Flag DayWise]={1}>}DISTINCT [Employee Code])+$(vTest))/2))/
Count({$<Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Cal_Month ID]={"<=$(=Max([Cal_Month ID]))"}>}DISTINCT [Cal_Month ID]))*12),Cal_Month)),'#0.00%')