6 Replies Latest reply on Oct 8, 2016 10:10 PM by Sandeep Kotha

    Week Calculation field Problem??

    Sandeep Kotha

      Hi All,


      I have a question on Week Calculation field.


      I have Below fields :


      1. Month: It consists of few months data.

      2.Week:    It consists of Week  numbers 1,2,3,4 or 5. Every month either have 4 or 5 weeks.Based on the respective month,it would have either 4 or 5 as the maximum value.

      3.Sales : It has the respective Week Sales Value.


      My question is that:


      I want to create a calculation field as "Sales based on on max(Week)" so that when I click any month, it should give the respective maximum week Sales value.

      I have written A calculation field as below.But it is not giving as per my requirement.


      If [Week]={fixed:max([Week])} then Sales else 0


      When I apply this formula, it is giving value as :

      Whichever month has 5 weeks ,it is giving corresponding sales value and the rest of the months as zero sales value.


      I have attached the workbook for reference.In the workbook,only August is giving values and the rest is giving as zero values.


      Could someone please help me on this requirement?


      Best Wishes,