0
Can't get results to exclude a field value of 0.
I am having more difficulty than I should in having this following formula exclude any records that have 0 value in my 'contact attempts' field
let curRec := this;
let xStart := 'Start Date';
let xEnd := 'End Date';
let x := (select Leads
where 'Contact Attempts' != "0" and 'Lead Entered Date' <= xEnd and
'Lead Student Type' = 2);
min(x.'Lead Nurture Days')
I have attempted using number function as well with no result.
3 replies
-
Tried this as well
let curRec := this; let xStart := 'Start Date'; let xEnd := 'End Date'; let x := (select Leads where number('Contact Attempts') >= 1 and 'Lead Entered Date' >= xStart and 'Lead Entered Date' <= xEnd and 'Lead Student Type' = 2); min(x.'Lead Nurture Days')
-
Okay, I ran the following in the console
let xStart := select 'Stats - Funnel Timeline'.'Start Date' let xEnd := select 'Stats - Funnel Timeline'.'End Date' select Leads where Status = 9 and number('Contact Attempts') >= 1 and date('Lead Entered Date') != 'Enrolled Date' and 'Lead Entered Date' >= xStart and 'Lead Entered Date' <= xEnd and 'Lead Student Type' = 2
I checked all the reference ID's for any 'Lead Nurture Days' that had the value of 0 and there wasn't a single one. So I am utterly confused as why it's returning a value of 0 for me. I do have "Lead Nurture Days' that don't have any value because they haven't met the criteria to have any data. Is it counting those as 0 too? It shouldn't be.
-
NVM, please delete this post.
Content aside
- Status Answered
- 6 mths agoLast active
- 3Replies
- 26Views
-
1
Following