Forum Discussion

Pastrupgaard's avatar
Pastrupgaard
Helper I
8 years ago
Solved

problem with sameperiodlastyear

Hi guys   I've created YTD in the following period 01/01 --> 10/27 with the following formula, but I'm having trouble with incorporating the sameperiodlastyear formula in it:   Actual YTD ($) =  ...
Need Help
  • Pastrupgaard's avatar
    Pastrupgaard
    8 years ago

    I got it to work with Calculate instead of TOTALYTD. Not sure what the difference is, but it works :)

     

    Thanks for the help

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Pastrupgaard

 

Try wrapping Datesbetween with sameperiodlastyear

 

SAMEPERIODLASTYEAR (DATESBETWEEN (_________))
Pastrupgaard's avatar
Pastrupgaard
Helper I
8 years ago

Hi Zubair_Muhammad

 

For some reason. it's not possible to have both the sameperiodlastyear and datesbetween in the same formula :(

 

 

Br
Pastrupgaard

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Pastrupgaard

     

    Remove the last bracket please

     

    I see a Red ")" in the image you posted

    • Pastrupgaard's avatar
      Pastrupgaard
      Helper I
      8 years ago

      Hi Zubair_Muhammad

       

      My bad :)

       

      I've corrected the formula, but there is no data output... I've recreated the data with a stupid workaround (so i know the data is there) and now i'm trying to make it smarter with this formula.

       

       

      Any smart ideas?

      Br
      Pastrupgaard

      • Pastrupgaard's avatar
        Pastrupgaard
        Helper I
        8 years ago

        I got it to work with Calculate instead of TOTALYTD. Not sure what the difference is, but it works :)

         

        Thanks for the help