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

Number of days between start fiscal period and end fiscal period

Hi

My user enter 'Fiscal Period' in the selection period between the values(start fiscal period & end fiscal period).

I want <b>number of days between</b> the <b>start fiscal period</b> and <b>end fiscal period.</b> So pls let me know how can we calculate the number of days between start fiscal period and end fiscal period.

pls let me knw

kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 06:53 AM

    Just create a formula in calculated key figure.

    right click in column area

    select cal keyfigure

    now you will find formula in bottom left plane.

    create 2 two formulas for start and end fasical periods.

    NOW endfasical - startfasical.

    YOu will get no of days.

    I hope it helps.

    Thanks,

    Madhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 10:17 AM

    Ravi,

    If you want to calculate the difference between the periods then you need to use the Formulae variable. Create Two Formulae variable and write a formulae based on those two formulae variables saying that FV1-FV2.

    These two formulae variables can be created in the formula creation scren...

    Regards,

    Gattu

    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.