5 Replies Latest reply: Jun 8, 2018 1:19 PM by Sunny Talwar RSS

    Adding Current Moth to Expression

    Elizabeth Viso

      Hello,

       

      I currently have an inventory count :

       

      IF(Building= 'UMHC - BASCOM PALMER EYE INSTITUTE', Count(DISTINCT Barcode), Barcode)

       

      Which works fine but it's doubling because this inventory has a monthly and a quarterly inventory, so I think my solution is to add to the expression to count only for the current month's inventory but each time I try I get an error. I tried adding Month = {"$(=MaxString(Month))"} to the expression but that doesn't seem to work.

       

      Any ideas? Thanks!