Forum Discussion

toziu's avatar
toziu
Regular Visitor
2 years ago
Solved

question about sameperiodlastyear

This is my original form  sheet1 date             quantity 2017/1/1         1 2017/1/2         1 2017/1/3         1 2017/3/25       1 2018/3/5         1   then i use calendar(FIRSTDATE('Sheet...
  • Vallirajap's avatar
    2 years ago

    Hii toziu 

    In your scenario, you used the sameperiodlastyear function to calculate the quantity of the whole previous year, 2017.


    sameperiodlastyear - It does not consider the date; it only considers the whole year.

     

    Thank you