Forum Discussion

Brendy_P's avatar
Brendy_P
Icon for Helper I rankHelper I
9 months ago
Solved

LY Fiscal Calculation

Hi All, Hopefully I can explain my dilemma adequately for you to help me. Thank you in advance. I am looking to calculate last years total from my Calendar table which is based on my company's fisc...
  • amitchandak's avatar
    amitchandak
    9 months ago

    Brendy_P , If you have Oct-2025 or onward 

    New Calendar 

    Do these entries 

    Formula 

    YTD FY = CALCULATE([Net], DATESYTD('FY'))
Brendy_P's avatar
Brendy_P
Icon for Helper I rankHelper I
9 months ago

Hi  amitchandak

I have looked at the blog and have already got the enhanced calendar option. I have followed the instructions but I can't seem to find the calendar created. I will need to do a bit more reding on it. Thank you for replying

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    9 months ago

    Brendy_P , If you have Oct-2025 or onward 

    New Calendar 

    Do these entries 

    Formula 

    YTD FY = CALCULATE([Net], DATESYTD('FY'))
    • Brendy_P's avatar
      Brendy_P
      Icon for Helper I rankHelper I
      9 months ago

      Hi

      amitchandak Praful_Potphode MohdZaid_ 

      I appreciate and would like to thank you all for your help. I have since found out that my company uses a 4-4-5 week calendar. Having said that amitchandak suggestion probably answers my qustion. Thank you all