8 Replies Latest reply on May 27, 2019 11:54 PM by Sree Renganathan Murugesan

    Can we store a value provided in parameters by the end user

    Sree Renganathan Murugesan

      Hi All,

       

      I have received a request from the user that, we have three parameter filters...

       

      Only after the user provide the value to the third filter, the calculated field should trigger...Please find below

       

      If ISNULL( [Parameter3] )

      THEN NULL

      ELSE

      [parameter1]+[parameter2]+[parameter3]

      END

       

      Consider at first user provided 1,1,1

      Then the result will be3

       

      But Now when user changed the value for parameter 1 & 2 and not for three...

      in this case it is 2,3,1...(note: parameter 3 is not change)

       

      So, now since the third parameter is not changed, the calculated field should not provide any results.

       

      Is there is any way to achieve, I have a idea of using like

       

      If ISNULL([parameter3]) or ([previous value of parameter3] = [current value of parameter3])

      THEN NULL

      ELSE

      [parameter1]+[parameter2]+[parameter3]

      END.

       

      Is there is any way to store the value provided by user in parameter...or any other way to achieve this?

       

      Regards,

      Sree