Skip to Content
avatar image
Former Member

YTD value = month value when i put the 0FISPER above the columns ratios


Hello Gurus,

I have a 0fiscper in the prompt

In my report I have a YTD and it works fine.

But when I drag 0FISCPER above the key figures, YTD becomes equal to the amount of the month.

I will wish for example for Period 2 that YTD sums period 1 and 2 not only 2.

Do you have an idea ?

Regards,

Thierry

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 19, 2014 at 08:41 AM

    up!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi,

      have you tried the cumulative function for the key figure and see if it meets your requirement.

      regards,

      Arvind.

  • Sep 17, 2014 at 03:40 PM

    Hi Thierry,

          Can you please share your query design and sample output of the report? It will be more clear to analyze and respond.

    Refer YTD Based on Fiscal Year Period without cmod code if it helps.

    Thanks

    Umashankar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Premalatha,

      I want  a YTD not only precalculated from Prompt 0FISCPER but also dynmamic if the user drag 0CALMONTH2 above KF

      For my YTD i use a user-exit variable.

      This user_exit calculate a period from the enter user value

      Example : 008.2014   => YTD    001.20014 <-> 008.2014

      It works fine but if the user drag  0CALMONTH2 above the KF

      The YTD = 0CALMONTH2 value  not the sum from 001.2014 to  0CALMONTH2

      I don't use formula yet;

      This is my goal :


      The columns month are from navigation user.

      Only two KF in this rapport.

      is-there a way to meet my goal ?

      Regards,

      Thierry

      goal.png (4.6 kB)
  • avatar image
    Former Member
    Sep 19, 2014 at 09:28 AM

    Thanks !!!

    Add comment
    10|10000 characters needed characters exceeded