Set Analysis with two values, one with null

[pascos88]

Hello,

I need to write a set analysis function with two value and one should filter for the value not equals to null..

count({<CampaignID={$(v_This_Year)} , prt_drop =("NULL")  >} DataUpd_Conf)...

something like this..

Any idea ?

Best,

[ppeterson1]

count({< CampaignID = {$(v_This_Year)} , prt_drop -= {'NULL'} >} DataUpd_Conf)

I believe that the above will be the case, if you are looking for when prt_drop is not equal to 'NULL'. This will not account for errors in NULL ie. null, nUll, Null, etc.

Hope this helps,

Paul

[YoussefBelloum]

Hi,

try this:

=count({<CampaignID={$(v_This_Year)} , prt_drop =("=len(trim(prt_drop ))<>0")  >} DataUpd_Conf)...

[jonathandienst]

>>and one should filter for the value not equals to null..

Count({<CampaignID = {$(v_This_Year)}, prt_drop ={'*'}>} DataUpd_Conf)

[pascos88]

Hi Thanks for the answer, something wrong.

The result give me 0, but should be different.

I should count all the DataUpd_conf where CampaignID = 'v_this_year'  and prt_drop is not null..

This should be the logic.

Can you see something wrong in my set Analysis?

Thanks again

[pascos88]

I just relized that I can also have something like this:

=count({<CampaignID={$(v_This_Year)}>} DataUpd_Conf) - count (prt_drop)

and I got the right result..

But it will be nice to see also the other solution, and how use it in the Set Analysis

[YoussefBelloum]

nothing is wrong on the expression above..

what do you have on the v_This_Year variable ?

would yo be able to share sample data or app ?