Compare two different fiscal period in Bex

[Former Member]

Hi ,

I need to compare between fiscal period through formula variable ?
Note : There is no user user selection on Fiscal Period. Expecting to achieve without involving code.

Eg : If Start Period <= Posting Period AND Billing Period >=End Period

Then 1 Else 0

Regards,

Pre Dev

[ccc_ccc · Accepted solution]

Hi Pre Dev,

Yes we can compare two different fiscal periods in BEx.

• Place all 4 fiscal periods in ROWs
• Create "Replacement path" variables for all 4 fiscal periods
• Create new formula write if then logic as like below.

(Start Period <= Posting Period) AND (Billing Period >= End Period) * 1 + 0 .

for more information about If the else statement in BEx check in google.

• Execute report and check result.

Regards

Nanda

[Loed]

Hi Pre,

Can you post the screenshot of your query? The suggestion of Nanda should work. Maybe you misconfigured something incorrectly.

Regards,

Loed

[ccc_ccc]

Hi Pre Dev,

In that case, you may check option "Virtual Key figure" .

Regards

Nanda

[Former Member]

Hi Nanda ,

Thanks for the reply , I tried it but I was getting below error

"Formula variable "POS PD" is used in formula element Fiscal Period Condition. It is to be replaced from the characteristic 0FISCPER or from an attribute of the characteristic 0FISCPER. However, the query characteristics STRT PD, ENDPD, 0FISCPER, for example, references 0FISCPER. Therefore, replacement is not possible and is not supported. "

I tried changing the offset too , Because its compounded with Fiscal Variant. Any further ideas ?

Regards,
Pre Dev