2 Replies Latest reply on Dec 2, 2016 12:25 AM by Fabio Guimaraes

    How can I create this formula: (40%*Variable1 + 30%*Variable2 + 30%Variable3)

    Fabio Guimaraes

      Hi there!

       

      I have 3 calculated fields but one is a "Quick Table Calculation".

      I want to create a new calculated field using a percentage of every variable.

       

      I came up with something like this, but didn't work:

       

      (40%* SUM([FixedAVGHourSession]) + 30% SUM([FixedAVGDayofWeekHourSession]) + 30% WINDOW_AVG(SUM([Sessions]), -7, -1))

       

      I appreciate any help here