February 19, 2010 at 2:35 pm
Hi All,
I have a scenario where i need to find the sales amount for yesterday and current day, and then i need to subtract currentday sales amount value from yesterday sales amount value. To do this i have written an calculated measure.
I am able to get the exact value what i require from the calculation. But i am facing a strange problem here at the granular level of data i am getting exact value what i expect but at the sub totals and totals level i was getting the value which is not same as sum of all the filed value. for your reference i putting an example below.
10/1/200910/2/200910/3/200910/4/2009
WARed Cycle41 3 1
Blue Cycle13 2
Totals 54 5 1
CARed Cycle2 1 10
Green Cycle13 5 1
Totals 1012 15 20
Grand Totals 2030 23 34
As shown in the above example instead of getting totals values as WA - Totals i am getting wrong totals like CA-Totals.
I am not sure what is causing problem, for the calculated measure i even used scope.
Could some one help me in solving this.
Thanks In Advance.
July 13, 2011 at 7:00 am
Hey,
Do let me know in case any solution to this problem. I have been stuck with it for 3 days, and its freaking me out. :w00t:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply