5 Replies Latest reply: Aug 22, 2017 1:31 PM by Channing Dionisopoulos RSS

    Multiplying 2 Expressions

    Channing Dionisopoulos

      Hi all!

       

      I have 2 calculated expressions.  One column is a simple sum of a dollar amount.  The other column is a percentage calculation, with the relative box checked to make the percentages relative to the whole.  I want to multiply these two columns together, but it will not work since one column is relative and the other is not.  Can I multiply 2 expressions using the 'Label' I created for each expression?  Is there a function I can use to make one part of the equation relative and the other not relative?

       

      Does anyone have any idea how to fix this?

       

      Thank you