Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
Specialist
Specialist

Meaning of -{0} inside set expression ?

Hello Fellow developers,

I was trying to get the meaning of - {0}, though i know - minus mean means  exclude when is used along with a column name , could some one explain me the meaning. I havee highlighted it in red.

COUNT({$<INDNUMBER={"=sum({<CYEAR=$(vCampaignYearSelected)},MasterCalendar.MonthName=>}DCDetails.TOTALDON )>0 and sum({<CAMPAIGNYEAR={$(=vCampaignYearSelected-1)},MasterCalendar.MonthName=>}DCDetails.TOTALDON )=0"} - {0},  CAMPAIGNYEAR=,MasterCalendar.MonthName=>}DISTINCT INDACCOUNTNUMBER)

Thx

SM

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Your advanced search used for the set modifier of INDNUMBER will return a set of INDNUMBERs where the two sum conditions are met, but whatever INDNUMBERs are returned, exclude 0 (zero) from the set.

View solution in original post

2 Replies
swuehl
MVP
MVP

Your advanced search used for the set modifier of INDNUMBER will return a set of INDNUMBERs where the two sum conditions are met, but whatever INDNUMBERs are returned, exclude 0 (zero) from the set.

swarup_malli
Specialist
Specialist
Author

Thank you, Swuel..