6 Replies Latest reply on Sep 1, 2016 4:41 AM by Sandeep Kotha

    Calculation field Problem

    Sandeep Kotha

      Hi All,

       

      I have question on calculated field.I have created a field called "label 1" as { FIXED :MAX([FiscalWeek])}.

       

      I used it in the title using the insert option as shown in the below snapshot.Current week is going on "Week -10" but i got it as "Week -9".But When I place the "Fiscalweek" field onto the rows shelf, it is showing "Week 10" level(check the below third snapshot).But the label1 shows the week 9 which is wrong as per the formulae.

       

      Not sure what went wrong.I have refreshed the tableau data as well.

       

       

       

       

       

       

       

      Could someone help me on this?

       

      Thank you.

       

      Best Wishes,

      Sandeep