1 Reply Latest reply on Nov 1, 2016 9:06 PM by Bill Lyons

    parameter doesn't refresh automatically as the underlying data is updated

    saurabh.c.0

      I am creating a calculated field Max(Date) . This is then assigned to a parameter

       

      My requirement is:

       

      if [parameter named max date]=[Last day of current month] then

      //some logic

       

      Problem :

      When new data gets added to the backend and I refresh the extracts, The calculated field is able to get the correct Max(Date) but it doesn't assign this value to the parameter automatically.(i need to do it manually). How to resolve this issue. I tried replacing the

       

      if [parameter named max date]=[Last day of current month] then //logic

      with

      if [Max(Date)]=[Last day of current month] then//logic

      but then it gives error saying cannot mix aggregate and non-aggregates.