Hi Experts,
Today I've faced a problem on ALTERNATIVE STATE. I've dimensions viz Region, SaleOffice, SalesGroup, Distributor, Market, RetailerCategory, RetailerClass, SalesMan.
I've used the following expression
Count({[Group1]<Year={$(=Max(Year))},DATE={'>=$(vStartDate)<=$(vEndDate)'},Month=,Quarter=,HalfYearFin=,Day=,[Region]=$::[Region],
[Sales Group]=$::[Sales Group],[Sales Office]=$::[Sales Office],[Customer]=$::[Customer],[Customer Town]=$::[Customer Town]
,SalesManDFSName=$::SalesManDFSName,RouteMKTName=$::RouteMKTName,RetailerName=$::RetailerName
>} SaleValue)
Outcome of the above expression is 16000.
But when I use Count({<Year={$(=Max(Year))},DATE={'>=$(vStartDate)<=$(vEndDate)'},Month=,Quarter=,HalfYearFin=,Day= >} SaleValue) , it results 21000.
Is there any mistake? Please help me to get rid of this problem.
Thanks in advanced.