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

    Adding Current Moth to Expression

    Elizabeth Viso



      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!