Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have list of users for different months: e.g.
Month - 2022 Dec and records = B, C, D, H
Month - 2023 Jan and records = A, C, D, E, F
Month - 2023 Feb and records = A, B, D, G, H
What is the formula to count new records in 2023 FEB only? Answer should be = 1 for "G" only.
I suppose you also have respective dates correlating to you month-year column, Lets Name the Column Date.
Try this:
Count({<records=e({<Date={"<$(=MonthStart(Max(Date)))"}>})>}records)
I suppose you also have respective dates correlating to you month-year column, Lets Name the Column Date.
Try this:
Count({<records=e({<Date={"<$(=MonthStart(Max(Date)))"}>})>}records)
Thank you so much - the formula works!