4 Replies Latest reply on May 31, 2016 5:48 AM by Yaniv Bordeynik

    Calculated field/Parameter based on an SQL statement(Oracle)

    Yaniv Bordeynik

      Hi All

      I would like to color a number frame, something like this

      2.JPG

      Until now I did it by changing manually the parameter for the Budget and now I trying to do this automaticly.

      My question is if there is a way to create a calculated field based on an sql query.

       

      For example in this image I would like to create a calculated field or a parameter that holds the value

      (select num_of_customers from tmp_table where product = 'alpha' and type = 'Budget')

       

      1.JPG

       

      Thanks in advance

       

      Yaniv