2 Replies Latest reply: Oct 25, 2011 8:52 AM by Yousef Amarneh RSS

    the word "Total" in expressions

    Yousef Amarneh

      Dear All,

      I have the below case:


      [supply] is the summation of 12columns and each column of these columns contains a complicated equation andmulti IF statements, what I need is how to get the total of this expression forexample:
      column X is [supply] divided by TheTotal of [supply] multiplied by another value.



      X=[Supply]/Total ([Supply])* Number


      My questions is how can I writean expression to get the above equation , although I tried the below equation:

      [supply]/sum(Total ([supply])) *Number 

      Our the problem is the yellow highlighted above!


      Please advise