how to suppress rows with 0's and '-'

[#1]

I am working on information related to donors, for years 2010 and 2009. I want to supress the rows which is having 0 donors in 2010. I have to use either setanalysis or if cond...but I am unable to do...please help me

[SunilChauhan]

if( isnull(donors)=0,donors)

then supress null

hope this works

if not understand correctly then share a sample.

[#3]

I supreesd nulls so I eliminated 0's but still m getting '_' . How should I supress the rows having '_'

[swuehl]

Please describe your current setting, by listing your (calculated?) dimension and your expressions.

Or post your application here (upload available in the advanced editor).

It's getting hard to know what your problem is, also too many different approaches around.

[#5]

Hi Pramodreddy,

You want to supress all the rows with 0 donors in 2010. If I understand what you asking, is that  you want to do so regardless of what you had as donors in 2009 (in the sam rows) ?

Ok, since " Sum({$<CAMPAIGNYEAR ={ $(vCurrentYear)},TrackParam.CAMPAIGNSTATUS={'F'},TrackParam.CAMPAIGNACCOUNT={'18'},TrackParam.CAMPAIGNTYPE={'empl'}>}TrackParm.NUMBEROFDONORS) "  is the expression that calculate the numbers of donors for the current year, I think you should just write the following code with an "If" condition, try it out:

= IF ( Sum({$<CAMPAIGNYEAR ={ $(vCurrentYear)},TrackParam.CAMPAIGNSTATUS={'F'},TrackParam.CAMPAIGNACCOUNT={'18'},TrackParam.CAMPAIGNTYPE={'empl'}>}TrackParm.NUMBEROFDONORS)= 0  OR 

Sum({$<CAMPAIGNYEAR ={ $(vCurrentYear)},TrackParam.CAMPAIGNSTATUS={'F'},TrackParam.CAMPAIGNACCOUNT={'18'},TrackParam.CAMPAIGNTYPE={'empl'}>}TrackParm.NUMBEROFDONORS)= ' ' , False() ,  Organizations.NAME1)

[swarup_malli]

Pramod,

If(sum({$<CAMPAIGNYEAR = {$(=num(vCurrentYear))},TrackParm.CAMPAIGNSTATUS = {"F"},TrackParm.CAMPAIGNACCOUNT = {"18"},TrackParm.CAMPAIGNTYPE= {"empl"}>}TrackParm.NUMBEROFDONORS)>0 or Null(), sum({$<CAMPAIGNYEAR = {$(=num(vCurrentYear-1))},TrackParm.CAMPAIGNSTATUS = {"F"},TrackParm.CAMPAIGNACCOUNT = {"18"},TrackParm.CAMPAIGNTYPE= {"empl"}>}TrackParm.NUMBEROFDONORS))

This should work

Regards

Swarup

[#7 · Accepted solution]

It worked!!!