Skip to Content
avatar image
Former Member

Compare two different fiscal period in Bex

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 07, 2016 at 05:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 08, 2016 at 05:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 04:28 PM

    Hi Pre Dev,

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

    Regards

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 21, 2016 at 07:55 AM

    Hi Pre,

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

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded