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

[its_anandrjs]

Hi,

Can you check that to store the summation value in any variable and use the variable in yellow marked area

Like

[supply]/ $(vSummation) *Number

Rgds

Anand

[Yousef_Amarneh]

It's very complicated and I can't use it in a variable.

thank you for your reply