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


      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')




      Thanks in advance