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
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
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