Skip to Content
author's profile photo Former Member
Former Member

Run time query calculation

hello

I'm building a KPI in my query.

I need to calculte a value which should be(current date) - Start date.

Current date is the date when report is running

Or

A date which can be entered in the selection screen.

thanks for your help.

regards

meps

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 20, 2005 at 05:29 PM

    Create 3 hidden Delimited kf ...

    1 - Delimited by Current Date variable

    2 - Delimited by a USer Exit variable that is equal, if evaluated, to Current Date or sy-datum.

    3 - Delimited by Start Date variable

    and then a Formula based on the difference of these 2 and 3. The first Delimited KF is needed to have the option of a manual entry to be replaced.

    Hope I understood your question

    GFV

    Message was edited by: Gianfranco Vallese

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2005 at 05:39 PM

    HEllo

    What is Delimited keyfigure.

    My requirement is

    already available field in cube start date

    A B (B-A)

    start date current date formula

    (available) (not availble) created in QRy

    01.01.05 20.01.05 19

    03.01.05 20.01.05 17

    when I run the query I should get above one when I run it tomorrow

    A B (B-A)

    start date current date formula

    (available) (not availble) created in QRy

    01.01.05 21.01.05 20

    03.01.05 21.01.05 18

    Hope this is clear.

    regards

    Meps

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.