Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Balraj
For your detailed explanation