This content has been marked as final. Show 2 replies
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!