Using a Look Up value to do math

Ask for Help
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.

1 Like
3

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

2 Likes
4

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

1 Like
5

Just solved one of the issues I’ve been trying to fix for the last few hours, thanks to @Robert_Petitto and @Jeff_Hager - thanks dudes! Also, the lookup column can pull from a math column for this to work too :+1:

2 Likes