9 Replies Latest reply on May 31, 2016 7:58 AM by Bassem Khalil

    Creating one calculated field that applies to all variables

    Prasad Hebbar

      Hi experts,


      I have ratings for few variables and I need to calculate the Topbox% for these ratings.


      Topbox = round(sum(if[Recommendation]>=9 then [weight] else null end)/sum([weight]),6)


      Instead of creating the Topbox multiple times for multiple variables, is there an option to create one variable for Topbox as per the above calculation and then apply this to all variables.


      Attaching the workbook in which I have calculated Topbox for Recommendation.

      I need similar Topbox calculated fields for other variables but not by creating multiple variables instead by creating one variable.


      Please help.