How to exclude null in set analysis

[#1]

I have a list of account,Project id ,Amount etc..  there are few blank for Project id's ,which i want to exclude those blanks project ids in the set analysis

how to i do that ?

for example

Account	Project ID	Amount
8150	100XYZ	-42459
8150		-5195

i want to exclude -5195 value , how do i write in the set analysis ?

i tried using sum({<Project ID-={ ' '}>} Amount) but this set analysis is not working.

[Gysbert_Wassenaar]

Try: {<Project ID={'*'}>} . That should filter out the nulls. If you want to filter out empty strings try {<Project ID-={''}>}

[sunny_talwar]

Somehow for me * alone did not work. I always had to use {'*?'}. If what Gysbert‌ does not work, you can give this a try as well:

{<Project ID={'*?'}>}

HTH

Best,

Sunny