4 Replies Latest reply: Apr 16, 2018 7:37 PM by Rachel Delany RSS

    Dynamic MTD cacl

    surya j

      Hi

       

      I have weekly report in which one of the calculated field i have monthtodate & networking days.

      I have a filter which has the weekend dates listed. If the user looks for the previous month week info the calculated field is taking the current month to date count(Below mentioned is the formula which i used).But that is wrong.

       

      So is it possible to make Month to Date variable to behave dynamically depends on the selected week in the filter?

       

      Formula:

      =(Sum({<[Processed_Date.autoCalendar.Month]={'$(vMonth)'},[Seg - Roll]={'Total RTF'}>}

      Rolled_To_Amount_Plan))/Monthtodate*Netwrkngdaysinamonth