Skip to Content
avatar image
Former Member

Query?

My requirements are:

1) Take input variable as number of days

2)Subtract these days from the current date

3)Restrict key figure 'Amount' by values for date > the above calculated date.

How could I do this?

The problem I am facing is:

1) How to subtract the user entered days from current date and store it in a value.

2) How to restrict a key figure by the above stored value.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2007 at 07:29 AM

    Nikhil,

    Create a formula variable of the date you want to restrict values on. The date characteristic will appear in your rows but you can change it's display to No Display.

    Create a formula variable which is a Customer Exit for Today's date.

    Create a formula to subtract the date in your query from the For Variable for today's date. This 'Result' will give you a no. of days.

    Create a condition on 'Result' which has a variable allows the user input the no. of days. Only the no. of days entered will be displayed in your results.

    Regards

    Gill

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2007 at 07:09 AM

    Hi

    You have to write a Customer exit code. In that code you have to use offset-( number of days) and store in a internal table to restrict the kf values by amount

    Regards

    N Ganesh

    Add comment
    10|10000 characters needed characters exceeded