Help

Calculation on a lookup field

Topic Labels: Formulas
1390 2
cancel
Showing results for 
Search instead for 
Did you mean: 
LUCA_MANGIONE
5 - Automation Enthusiast
5 - Automation Enthusiast

Hallo

I am trying to apply a multiplier to a lookup field based on a checkbox or multiple selection.
In short, if the checkbox is checked, a lookup would be multiplied by a certain amount (for example 200), else it would not. Similar to:

IF ((checkbox)=1, LOOKUP*200, LOOKUP)

Another possibility would be:
IF ((multiple select)=A, LOOKUPx200, (multiple select)=B, LOOKUPx300,(multiple select)=C, LOOKUPx400)

Hope this is clear - strong text is this feasible?

best

Luca

2 Replies 2
Mehul_Bhandari
6 - Interface Innovator
6 - Interface Innovator

Hi, as a fundamental rule - if you want to perform calculations on lookup field/column - you need to use ROLL UP and enter formula/IF Condition etc.

Alternately, you can Look Up and make a new column adjacent and configure it to FORMULA.But this is a two step process. Above is a single step process.

Hope it helps!

LUCA_MANGIONE
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks

I cannot understand how you can perform a rollup and multiply a field to a another value.
can you pls explain?

Thanks

Luca