Skip to Content

Previous value should be used - Fox Formula - Code

Hi All,

I have input field in a report(ZINPUT).The value is entered weekly and If no new value is entered, then the previous value should be used in the field. Can any one please provide a code so I can fix this issue of mine.

Regards

S

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Nov 08, 2011 at 09:40 AM

    ANY Help PLZ

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2011 at 10:27 AM

    Hi S,

    I think you can use customer exit for that .

    Try to pass last value at i step =1 .It will appear in selection screen .

    If user want to change the input he will have to change it manually .

    I have one question ?how you will decide previous value ,is it will be last week or last used value to execute report ?

    Regards,

    Jaya Tiwari

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 08, 2011 at 11:04 AM

    Hi jaya tiwari ,

    Thank you for your Input. The issue is I have a input query,customer will run the report weekly. In that report have field(ZINPUT) if thats not filled in for this week, when the query data is saved to the Cube it should write previous week value of ZINPUT. So I need fox formula.

    Thanks

    SK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 09, 2011 at 02:58 PM

    Hi.

    Can any one drop me a sample code for this. I don't know the syntax as never done coding(fox formula) before.

    Thanks

    SK

    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.