Different results for same formula in ASO cube ?
SummaryDifferent results for same formula in ASO cube ?
I have a same below formula in both environments(Prod and Test) with exact same outline for ASO cube. But when I am retrieving the results in smartview it's showing different results. Can you please help me what might be the problem.
Volume-Mix Variance = IIF(Is(Scenario.CurrentMember, Actual) AND Is(Years.CurrentMember, &ActYr),
(([Sales] - ([Sales],[Corp_Plan])) * ([PGM],[Corp_Plan])) ,