Explain

[smilingjohn]

Hi All ,

Can someone explain me the below expression , please

what is happening .

What is Lead_SubCatergory doing  and what is Lead_Source ? what doesn {'*'}-... means

num(Count(DISTINCT

  {$<

  Date = {">=$(StartDate)<=$(EndDate)"},

  Dept= P(Dept_R),

         Lead_SubCategory={'Internet','Regional','Special Program','Dealer Sourced','Dealer Entered','Third Party'},

         Lead_Source={'*'}-{'Showroom','Phone','lmn','Dealer Third Party'},

                [Load]={'Phone','Email','Text'}       

  >} Cost_ID

  )),

Regards

John

[Anonymous · Accepted solution]

From your expression:

You are counting distinct Cost_ID which meets the following conditions:

1) Date falls between start & end date

2) All possible department available with regards of your selection like P(Dept_R)

3) Where Lead Subcategory is equal to : Internet','Regional','Special Program','Dealer Sourced','Dealer Entered','Third Party

4) Where Lead Source does not equal to ='Showroom','Phone','lmn','Dealer Third Party'

{'*'} means all the available values of fields

[smilingjohn]

Thanks Balraj

For your detailed explanation