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.

       

      [Supply]=[Peak]+[Budget]+[Energy]+[Insurance]+[Penalty]+[revtmp]+[security]+[Excess]+[Delivery]+[Access]+[Service]+[incidents]

      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