YTD time summary excluding current month

Options
ddamerji
ddamerji Member, ALL USERS, Partner, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Hello community!

 

Is there a way or a workaround for the YTD time summary to exclude the current month? I would need to do this for multiple line items in multiple modules that have different time summary methods.

 

I guess one solution would be to always postpone the update current month period with a full month, but it feels like there should be a better solution. 

 

Regards,

Daniel 

Tagged:

Comments

  • ddamerji
    ddamerji Member, ALL USERS, Partner, Certified Model Builder Posts: 4 Occasional Contributor

    Hi @TimWard70  and @rob_marshall 

     

    So your formula solution would give me the right answer but correct me if I am wrong, not in the way I need it to be formatted. 

     

    What I am looking for is as an example this: My time summary is average and the models current period is Mars. Here the YTD includes the month of Mars because of how YTD is programmed/defined. But I would like the YTD summary column to take the average only for the months June21 - Feb22, meaning instead of 204,7 it should be 227,5. 

     

    ddamerji_1-1648818277197.png

     

    This is just a dummy line item, in the real model I have multiple modules with multiple line items, subjected to different summary methods, but all of them needs to exclude the current period month regardless of method used. 

    Is this possible or is there a smart workaround? 

     

    Best regards,

    Daniel 

     

     

Categories