10 Replies Latest reply: Oct 17, 2017 4:25 AM by Martin Hamilton RSS

    Count by records created before current month

    Martin Hamilton

      Hi - using sense I wish to use a KPI to show a calculation which counts records created before the current MonthName (where the field name is SUBS_CONNECTED_MONTH)

       

      My expression works fine when selecting dates equal to todays Month Name:

       

      Count({<SUB_CONNECTED_MONTH={"$(vCurrentMonth)"}>}Distinct SUBS_NUMBER)

       

      Where I have a variable of :

       

      vCurrentMonth:

       

      =MonthName(Today(1))

       

      I have tried to use a not equal value of <> instead of = but still cant seem to get it to work?

       

      Any ideas or suggestions?

       

      thanks

       

      Martin