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

BPS FOXCODE

Hi BI Experts,

Can anyone help me in writing syntax for FOX CODE in BPS?

I have a requirment to calcuate percentage for current year planned sales based on my Previous year. I should be able to give values at runtime which reflects accordingly.

Thanks in advance,

Pushpa.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2008 at 11:17 AM

    Hi,

    Create a variable of type characteristic value and user defined variable in BPS for current year planned sales. Keep the replacement type as user defined. Check input required by user and the other check box also. Suppose the variable is "salecurrent"

    You must be having some version to defferentiate between planned data and actuals. If not then also no problem.

    Create a fox type planning function. Fields to be changed can be the keyfigure name (example sales), year.

    First create a local variable (example sale) and fetch the value of salecurrent and store it in sale.

    sale = varv (salecurrent).

    The calculation would be sale * 100 / {sales, 2008}.

    This will calculate the percentage. This result can be stored in some other keyfigure as per your convinence. If you are storing in some other keyfigure (example perc), then the code should look something like

    var sale type 0keyfigure. - specify the keyfigure

    {perc, 2009} = sale * 100 / {sales, 2008}.

    In the above formula, the percentage has been stored in perc keyfigure for the year 2009. You can customize it more according to your requirement.

    Please award points if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2008 at 06:24 AM

    HI

    u can use variables for the same and call them in ur fox code using

    varv function.

    srini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2008 at 04:35 AM

    HiNilanjan,

    Thanks a lot. Your reply helped me a lot. Can you tell me how can we define variable of type DATE & CHAR.

    Thanks in advance

    Pushpa M

    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.