How to excluded null values(-) in Set analysis

[Anonymous]

Hi ..

I have one field with null values means -.i have remove null values in set analysis.

please find following attachment i has agentskill targetid it contains null i have to remove null values in set analysis.

please help me..

Thanks,

[sujeetsingh]

You can try {*} to select all values that should exclude the null value and - {''} should get rid of the blank values.

=sum({$<resolveddate ={'*'}-{''}>} 1)

[Anonymous]

Hi Sujeet..

Thanks for yoyr reply

I tried this systax but its not working.Can you please find my attachment in this AGENTSKILLTARGET ID Contains null values i have to remove null values..Help me..

Thanks..

[PradeepReddy]

you can use NULLASVALUE in script in order to assign a string/numeric default value for nulls:

Script:

NULLASVALUE Filed;

Set NullValue = 'N/A';

Expression:

Count({<Field={'N/A'}>}Field)

[PrashantSangle]

Hi,

Try Like

Sum({<NullITakingField={"=not isnull(NullTakingField)"}>}Sales)

Regards

[Anonymous]

Hi Max..

Thanks for your reply..

If apply same syntax it does not working fine..

Thnaks,

[anbu1984]

Check this

[PrashantSangle]

Hi,

What is your expected count??

Regards

[Anonymous]

Hi Anbu..

Thanks for your reply..

Trasing wise your formula currect.But when i create table box with acdDATE and agentskilltargetID.The agentskilltargetid has null values so it has count but your formula shows zero count..

Please help me

[anbu1984]

=count({<ACD_Date={'=Len(Trim(AgentSkillTargetID))=0'}>}DISTINCT ACD_Date)