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 :






      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?