Using a Look Up value to do math

Help & How To
#1

I am trying to create an invoicing system that is all interconnected, the template out there is really not adequate.

So my question:

I created a relation for a Service, then I create a look up to get the rate. So now I wanted to take the rate and multiply it by time to get an invoice amount. But I don’t have the option to do that because you can’t multiply or do any math operation on a look up value.

Any suggestions?

#2

You should be able to. Make sure the original column you’re bringing in is formatted as a number column.

#3

Also make sure the lookup isn’t coming from a multiple relation. It should be a single relation.

1 Like
#4

Thanks, I was able to figure it out with your help

1 Like