Skip to main content

Calculation on a lookup field

  • September 2, 2019
  • 2 replies
  • 29 views
L

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

M
Forum|alt.badge.img+1
  • Mehul_Bhandari
  • Known Participant
  • September 3, 2019

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!

L
  • LUCA_MANGIONE
  • Author
  • Participating Frequently
  • September 4, 2019

Thanks

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

Thanks

Luca

Terms & ConditionsAccessibility statement