Hello fellow Codans!
I am using data that only gives month and year, ex. 9/1/2020, 10/1/2020, 11/1/2020, ect. and have said data spanning multiple years in the same format. I’m wanting to represent sum numbers from specific years and am currently getting total from all years. Im aware of the Year function but I am not using it correctly.
I currently use TABLENAME.MONTH.Max( ).MonthName to show current show current month
I label this formula as (formula 1) [this month]
TABLENAME.MONTH.ListCombine(" ").unique( ).Sort( ).Nth(-3).MonthName( ).Last( ) to show the previous month
and label this formula as (Formula 2) [last month]
Using TABLENAME.UNITS.Filter(formula 1).Sum( ) gives me all the years units totaled (of course)
I have used a couple work arounds to get specific units from current year and current month with a sub table but have trouble displaying previous month’s said current units total given within a year.
Would love any input on this bad boi, and understand there’s many ways to skin the cat so appreciate any and all!