May 29, 2012 at 7:22 am
Hi all,
Can someone help me with this expression .
I have a column which counts the no of ids in a table (count(fields!id.value). Now I have another column and I want to return an expression based on the count of the ids . For example, if(count(fields!id.value is Between 1-50, I want to return 1-50 in the column and if (count(fields!id.value is betweeen 51-200, I want to return 51-200 and so on.
May 29, 2012 at 7:46 am
Assuming this formula is happening on multiple rows within the detail of the report. Try something like this:
SWITCH(count(fields!id.value) <= 50,"1-50",count(fields!id.value)<=200,"51-200",count(fields!id.value)<=500,"201-500",1=1,"Greater than 500")
May 29, 2012 at 8:20 am
Thanks. works perfectly well
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply