Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

YTD last year

Hi everybody,   I calculate a YTD and i try to compute The total YTD for the last year but it's give me a wrong value, it show me the total of the previous year:   Net TO YTD = TOTALYTD(SUM('QUE...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi BhaveshPatel,

     

    I slice by month an by Year and also change my Expression to calculate "Total Net TO of Last Year" by putting a new filter in my CALCULATE Function to keep the expression doing the right calcul, because by slicing the value change.

     

    Best regards,

  • BhaveshPatel's avatar
    BhaveshPatel
    7 years ago

    Hi Anonymous 

     

    If you believe this answers your question, Please mark it as accepted solution so it can be helpful to others as well

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi BhaveshPatel,

 

I slice by month an by Year and also change my Expression to calculate "Total Net TO of Last Year" by putting a new filter in my CALCULATE Function to keep the expression doing the right calcul, because by slicing the value change.

 

Best regards,

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
7 years ago

Hi Anonymous 

 

If you believe this answers your question, Please mark it as accepted solution so it can be helpful to others as well