Group Months into Financial Year in Load Script

[stephen_schrims]

Hi, very new to this.....I am looking to add a group for month/years by financial year (Starts May - Ends April)

(i.e May-2018, June-2018, July 2018, August-2018, September-2018, October-2018, November-2018, December-2018, January-2019, February-2019, March-2019 & April-2019 = 2018-2019)

Current Script....

"Month Closed",
num("Month Closed") AS [Month Closed Num],
monthname("Month Closed") AS [Month Closed MonthYear],
month("Month Closed") AS [Month Closed Month],
REPLACE(Yearname("Month Closed"),'-20','-') AS [Month Closed Year],

Really appreciate any help!

[Mauritz_SA · Accepted solution]

Hi Stephen

Try something like this:

If(Month("Month Closed")< 5,Year("Month Closed")-1&'-'&Year("Month Closed"),Year("Month Closed") & '-' & (Year("Month Closed")+1)) AS FinYear

Good luck.

Mauritz

[stephen_schrims]

Thanks for taking the time to look at that Mauritz, that worked perfectly. Much appreciated.