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

null
    • Dave_Irving
    • 9 mths ago
    • Reported - view

    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')
    • Dave_Irving
    • 9 mths ago
    • Reported - view

    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.

    • Dave_Irving
    • 9 mths ago
    • Reported - view

    NVM, please delete this post.

Login to reply

Content aside

  • Status Answered
  • 9 mths agoLast active
  • 3Replies
  • 29Views
  • 1 Following