Skip to Content
0

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

Feb 21, 2017 at 09:33 AM

128

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Trevor Dubinsky
Mar 01, 2017 at 06:11 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
RAJESH J Mar 02, 2017 at 07:55 AM
0

thank you Trevor Dubinsky

Share
10 |10000 characters needed characters left characters exceeded
RAJESH J Mar 02, 2017 at 09:41 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded