Lookup Formula

[Smitster]

Hi all,

I currently have a table, “Operations”.

This table contains a number of columns, the primary ones i’m interested in for the expression are:

OpID (Primary Key)
JobNumber
Operation
Intensity
PreviousIntensityEnabled
PreviousOp

There is also another column called IntensityText

I have two rows of data as follows:

OpID / JobNumber / Operation / Intensity / PreviousIntensityEnabled / PreviousOp

SP01.Operation1 / SP01 / Operation1 / 0.003 / No / NULL
SP01.Operation2 / SP01 / Operation2 / NULL / Yes / 1

I am working on a form where for the intensity section, if the [PreviousIntensityEnabled] is active i.e. has a “Yes” value, and an intensity value is available for the previous operation, then IntensityText column displays a message along the lines of “Please see previous intensity value”.

For Show_If, I currently have the formula as:

AND(
[ProcessIntensityEnabled]=“Yes”,
ISNOTBLANK(
LOOKUP(CONCATENATE([JobNumber], “.Operation”, [PreviousOp]), “Operations”, “OpID”, “Intensity”)
)
)

Display_Name is set to “Please see previous intensity value”

Unfortunately this isn’t currently working. What am I doing wrong?

Thanks,

[Aleksi · Accepted solution]

Try to use… LOOKUP(CONCATENATE([_THISROW].[JobNumber],“.Operation”,[_THISROW].[PreviousOp]),“Operations”,“OpID”,“Intensity”)

[Smitster]

Yes that’s done it, thank you

[Aleksi]

You’re welcome