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] =
– 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?