4 Replies Latest reply: Sep 8, 2014 4:45 PM by Cole Weatherson RSS

    Show Week Ending Date

    Cole Weatherson

      Hi all,

       

      I am currently trying to have a chart title show the week ending date whenever a Financial Week is selected. With the data I have, I have to do this by selecting the highest day (DAY_DT) of the selected week (FINANCIAL_WEEK). The code I have written so far is:

       

      If(GetSelectedCount(FINANCIAL_WEEK) >= 1, 'Wk Ending ' & ...

       

      And this is where I am stuck. I have tried combinations with FirstSortedValue but nothing seems to work, and it just returns "Wk Ending " when a week is selected. Any suggestions?