10 Replies Latest reply on Jun 28, 2017 2:50 AM by Simon Runc

    week spans two months, how to show one occurrence only?

    ammar.khwaira

      Hi

       

      my data has a date field, category and timing columns.  I want to show week names (Week 1, Week2,....) in each year/month.

       

      my goal is to calculate "time left" which is basically (100 - timing column).  I have created a LOD expression to calculate the 'time left' column, because each week have 100 hours available, and i want to subtract the timing used from those 100 hours.

       

      the results are accurate, but , Week 13 is showing twice (both in March and April 2017).  How can i show only one occurrence of Week 13 in this case ?

       

      Thanks