4 Replies Latest reply on Jun 12, 2018 2:23 PM by mircea.rusu.0

    Monthly calculation?

    mircea.rusu.0

      Hello,

       

      I have the following formula that calculates correctly a minimum data for the entire data set:

       

      MIN(if [Status]='Backlog' or [Status]='Missed deadline' then {fixed [Status]:MIN([Target Date])} END)

       

      Please advise how to change it in order to obtain the minimum per month, i.e. for each month of [Target Date]

       

      Thank you..