Function Module for calquater

[former_member184624]

Dear BW Experts,

In one of the BW report, User is entering CALQUATER as a input (20182). In the output, I want to show the data from 20182, 20183, 20184 and 20191. Can you please share, any standard function module which can get next quarters (20183, 20184 and 20191) as output. so that i can show in the report.

Thanks.

[rathy_moorthy2 · Accepted solution]

Not aware of a standard one for it.

But since quarter is only 4, you can easily create a custom one with following logic.

return

{

if (right substring (1)of user input not eq 4) then A = (user input + 1) else A=year+1 and 1

if (right substring (1)of A not eq 4) then B= (A + 1) else B =year+1 and 1

if (right substring (1)of B not eq 4) then C= (A + 1) else C =year+1 and 1

if (right substring (1)of C not eq 4) then D= (A + 1) else D =year+1 and 1

}

Hope it helps

Regards,

Rathy

[former_member184624 · Accepted solution]

Thank you. I have acheieved using offset on calquater info object.