Previous month not working - Set analysis

[#1]

hi i am attempting to show the previous month here, however it is not working according to plan.

the syntax seems correct however, so not sure if there is an underlying problem in the data.

any help would be greatly appreciated.

Best

Brad

=Count({$< inLeveransDatumMonth = {$(=Max(inLeveransDatumMonth)-1)}  >}

    (Inlev_Radnummer))

[Gysbert_Wassenaar · Accepted solution]

Your month field isn't a number, but a dual value. That complicates things. One way is to use this expression:

count({<inLeveransDatumMonth={'>=$(=max(inLeveransDatumMonth)-1)<=$(=max(inLeveransDatumMonth)-1)'}>}Inlev_Radnummer)

You could also create a numeric month field in the script and use that instead: autonumber(monthstart(MyDate),'MonthSerial') as MonthSerial

[Anonymous]

Unless there is a valid reason to use set analysis, this can work:

=Count(if(inLeveransDatumMonth = Max(all inLeveransDatumMonth)-1, Inlev_Radnummer))

[#4]

this actually works, really cool i can perhaps use it in other places, thanks Michael your a star!