How do I make this calculation work?
(([Major Visits])x([Assigned Time Depending On Equp.])+([Minor Visits]x[Assigned Time Depending On Equp._16])x[Equipment Qty], [Company] =
[_THISROW].[Company])
โ NOTE: I know the asterisk symbol is used for multiplying, though it also is used to make text BOLD, so I use the x to signify multiplication for my question.
I know I have some parentheses wrong, but it is not making it past the first two inputs.
It gives me this message.
"Arithmetic expression โ([Major Visits]*[Assigned Time Depending On Equp.])โ has inputs of an invalid type โUnknownโ
"
I know I should be able to multiply one column against another, so what am I missing here?
I figured it out.
I needed to have initial values in the columns of โ0โ, so the calculation had something to run against.
I put zero in all initial values that I am computing, and it accepted the expression.
Props to +1Steven Jeffery
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |