Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

TOTALYTD function, but for some rows use another formula

Hi all - I have this problem I can't really figure out how to solve. I have a table with 22 lines and I want measures by month and YTD. By month (yellow, left side below) works fine - no problem. However, in the YTD (blue, right side where I use "totalytd" function) I actually don't want the YTD in line 21 & 22, but instead I want:

Line 22: should be equal to February (or whatever month is chosen in the filter) line 22: 87,244

Line 21: should be line 22 minus line 20: 87,244 - (-27,813) = 115,057

 

Any suggestions ? 🙂

 

Thanks

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    If Feb the last month or Feb is selected Totalytd will have data till Feb. All the values are the sum of Jan and Feb. Why you think the last two are wrong?

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    You could use If formula to set a special condition for the last two values.