9 Replies Latest reply: Sep 26, 2017 10:28 AM by Meghann MacDonald RSS

    Formatting a Count Function

    Meghann MacDonald

      Hello,

      I have this function: Count(distinct {$<[DATE MODIFIED.autoCalendar.QuartersAgo]={">=0<=4"}>} [ASSET TITLE])

      Which counts the asset titles that have a Date Modified of between 0 and 4 quarters ago. I want to count the asset titles that have a date modified of between 0-4 quarters ago that DON'T have an x in the 'aging exemption field', which would be denoted by ........... [Aging Exemption] = 'x'

       

      How is this worked into the count function?

      Thanks.