November 11, 2013 at 1:20 pm
I am trying to Sum the percentage of increase or decrease in the Dataset.
Here is the expression I have to calculate the individual percentage Increase /Decrease based of current month and previous month
Formula is CurrentMonth-PreviousMonth/PreviousMonth
=IIF(Fields!PreviousMonth.Value = 0,0,
(Fields!CurrentMonth - Fields!PreviousMonth.Value)
/IIF(Fields!PreviousMonth.Value = 0,1,Fields!PreviousMonth.Value ))
This works perfectly fine.
When denominator is 0 it returns the output as 0 and when its a numeric value it calculates appropriately.
However , it gives me random numbers when I try to sum this...
Can anyone suggest the right way to sum it?
November 12, 2013 at 1:45 am
Can you attach a report image in Design mode?
Where do you put your formula? in a Matrix or in a Table?
Which is the sum scope?
I need some more info for help you...
November 12, 2013 at 7:06 am
Notwithstanding ndiro's reply, I would guess this
=IIF(Sum(Fields!PreviousMonth.Value) = 0,0,
(Sum(Fields!CurrentMonth) - Sum(Fields!PreviousMonth.Value))
/IIF(Sum(Fields!PreviousMonth.Value) = 0,1,Sum(Fields!PreviousMonth.Value)))
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply