Forum Discussion

Manjunathak's avatar
Manjunathak
New Contributor III
7 months ago

Calculation based on time parameter

I have declared CurrYear and CurrMonth to retrive year and month respectively. Dim CurrTime As String = api.Pov.Time.Name Dim CurrYear As Integer = TimeDimHelper.GetSubComponentsFromName(CurrTime)...
Finance
  • aformenti's avatar
    aformenti
    7 months ago

    So, you want to run the calc2 in 2024 only up until 2024M5? Nothing to be calculated beyond 2024m5? in that case:

    If CurrYear < 2024 then

Calc1

else If CurrYear.Equals(2024) AndAlso CurrMonth <= 5 Then 

calc2

end if

     

     

  • Henning's avatar
    Henning
    7 months ago

    Hi, in case you are trying to set up a member formula, consider using the built-in functionality to vary the member formula by time (and / or scenario type).

    Your pre-2024M5-calculation will be saved under "(Default Time)" and the post-2024M5-calculation will be saved in "2024M5". This will automatically apply the correct formula in the corresponding time periods.

     

    If that is not within your considerations, you can also use these functions instead of using TimeDimHelpers:

    Api.Time.GetYearFromId()
Api.Time.GetPeriodNumFromId()

    If you need more time functions, please try to rely as much as possible on native functions. This is more future proof and easier to maintain and read. You can e.g. also use this to get the POV prior year:

    Api.Time.GetYearFromId(Api.Time.GetPriorYearPeriodId())

     

Manjunathak's avatar
Manjunathak
New Contributor III

Hi aformenti ,

thanks you're right,

can you also help me to break the calculation based on 2024M5?

if it is lease or equal 2024M5 run calc

If currYear < 2024 Then

     Calc

Else If currYear = 2024 & currMonth <=5

    Calc

End If 

End If

 

  the above code is not working for me

 

Henning's avatar
Henning
Valued Contributor II
7 months ago

Hi, in case you are trying to set up a member formula, consider using the built-in functionality to vary the member formula by time (and / or scenario type).

Your pre-2024M5-calculation will be saved under "(Default Time)" and the post-2024M5-calculation will be saved in "2024M5". This will automatically apply the correct formula in the corresponding time periods.

 

If that is not within your considerations, you can also use these functions instead of using TimeDimHelpers:

Api.Time.GetYearFromId()
Api.Time.GetPeriodNumFromId()

If you need more time functions, please try to rely as much as possible on native functions. This is more future proof and easier to maintain and read. You can e.g. also use this to get the POV prior year:

Api.Time.GetYearFromId(Api.Time.GetPriorYearPeriodId())