Discussions

Expand all | Collapse all

Count the number of Cases by Month

  • 1.  Count the number of Cases by Month

    Posted 09-03-2018 13:09
    So I'm creating a custom reference with "SY-MM-YYYY-CASE-GENDER"
    This my current formula:
    "SY" 
    & "-" 
    & Month(ToDate([Date Created]))
    & "-"
    & Year(ToDate([Date Created]))
    & "-"
    Count(ToDate([Date Created])) <-- Current Problem
    & "-"
    & [Gender]

    How to count the number of records by month using formula-text?


  • 2.  RE: Count the number of Cases by Month

    Posted 09-03-2018 20:34
    I think that you will need to take a step back and explain your use case.  If you want to count the number of Cases per month, you can just make a Summary report.

    You may have a use case which does require the Values to be on records, and if you can explain that, there is likely a solution. 


  • 3.  RE: Count the number of Cases by Month

    Posted 10-10-2018 13:05
    Example, I created 3 records this month so the formula-text i made will show "PE-01-2018" "PE-02-2018" "PE-03-2018" then if it's the new month the first record i create will be "PE-01-2018"