DaysNumber function

The DaysNumber function allows you to retrieve the number of days set up on the period. For the consolidation scenarios, the value is read from the corresponding original period. Therefore, the following syntax

[LO].[X00000] := [C00000] / DaysNumber;

allows you to divide the value of the account C00000 by the number of days between the beginning of the scenario and the end of the run period.

The DaysNumber function can indicate a time jump and / or a periodic reading of the value:

  • DaysNumber(Per) reads the number of days of the current period
  • DaysNumber(Per(3)) reads the number of days of the last 3 months (rolling)
  • DaysNumber(Time.P3.Last, Per(3)) reads the number of days of the current quarter.