Skip to Content
avatar image
Former Member

It is possible to create fiscal year column from date column using lumira function

HI Folks,

It is possible to create fiscal year column from date column using lumira function?

i have requirement to create fiscal year april to march using lumira function.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 01, 2017 at 06:11 PM

    Well this depends on the data types being used and such like that. I will assume your dimension is a DATE type, and assuming that January to April belong to the previous fiscal year, then you could create a formula similar to:

    if (Month ({Date Dimension}) <= 4) then (Year({Date Dimension})-1) else Year({Date Dimension})

    Kind Regards,

    Trevor Dubinsky

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 02, 2017 at 07:55 AM

    thank you Trevor Dubinsky

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 02, 2017 at 09:41 AM

    it is possible to create Fiscal Year YTD & PYTD using SAP lumira Function?

    Add comment
    10|10000 characters needed characters exceeded