calculating the difference in columns
-
I dont know where and what is causing the below issue that I am facing.
I am trying to add a column to my existi
ng report which will calculate the percentage difference between
the of two value based on dates.I want to find the difference between only the recent and its previous date.
I used the below expression but seems its returning wrongs % values. looks like the dates are creating some problem.
Then I tried to follow steps mentioned in below link and it is a bit close but as you see the diference column is repeated
for every date(I want only for recent 2 month comparision).
http://www.bi-rootdata.com/2012/11/calculate-column-difference-in-matrix.html .=iif(
lookup(CStr(DateSerial(Year(Fields!monthly_date.value),Month(Fields!monthly_date.value),"1").AddDays(-1))
+CStr(Fields!indicator.value)
,CStr(Fields!monthly_date.value)+CStr(Fields!indicator.value)
,Fields!Total_revenue.value,"My_Dataset")=0,0
(Fields!Total_revenue.value -
lookup(CStr(DateSerial(Year(Fields!monthly_date.value),Month(Fields!monthly_date.value),"1").AddDays(-1))
+CStr(Fields!indicator.value)
,CStr(Fields!monthly_date.value)+CStr(Fields!indicator.value)
,Fields!Total_revenue.value,"My_Dataset")
*
lookup(CStr(DateSerial(Year(Fields!monthly_date.value),Month(Fields!monthly_date.value),"1").AddDays(-1))
+CStr(Fields!indicator.value)
,CStr(Fields!monthly_date.value)+CStr(Fields!indicator.value)
,Fields!Total_revenue.value,"My_Dataset")^-1
)Any suggestions or ideas on this would be very helpful for me.
(Image 1 is the source and image 2 is the design in ssrs and image 3 is the desired ourput)
-
can I get any help on this from the experts in this room ?
ng report which will calculate the percentage difference between Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply