3 Replies Latest reply: Nov 19, 2015 11:02 AM by Jordan Konicki RSS

    Count Mathematical Expressions

      Hello,

       

      I am trying to add a condition to my count statement in order to factor in if an amount is in between two others. The conditions go as this:

       

      1. The CERTIFICATION_EXPIRATION DATE must NOT be null or zero.

       

      2. The CERTIFICATION_EXPIRATION DATE minus vToday(Today's date) must be greater than or equal to 1 and less than or equal to 30.

       

      If these conditions are met, RTC_TITLE is to be counted. This is what I have so far with no luck:

       

      count( {$<CERTIFICATION_EXPIRATION_DATE -= {''}, CERTIFICATION_EXPIRATION_DATE -= {0} , CERTIFICATION_EXPIRATION_DATE-vToday = {"<=$(=(30))", ">=$(=(1))"}>} RTC_TITLE)

       

      Any help is appreciated!

       

      Thanks!