October 6, 2014 at 1:26 am
i have an ssrs report in which i have to calculate percentage.....
i wrote below expression
=IIF(sum(Fields!cost_center.Value)="Revenue",sum(Fields!RevResourceamount.Value),(sum(Fields!RevResourceamount.Value)-sum(Fields!Amount.Value))/sum(Fields!RevResourceamount.Value))*100
in the above expression RevResourceamount is the the column which contain both
'revenue' and 'resource count' amounts'
and 'Revenue' and 'ResourceCount' are stored in 'Cost_Center' column
and Amount is the column which contain total amount
but i have to filter only 'Revenue' amounts from 'RevResourceamount' column
after that i have to subtract (Revenue amount-Total amount)
and i have to devide that subtraction amount with Revenue amount
i have to calculate percentage like this...
but iam not getting
can any one please suggest me how to get this..
October 6, 2014 at 1:51 am
You cannot use sum on a text column. Is it possible to give some sample data and desired output?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply