Forum Discussion

Joshmarsteffens's avatar
Joshmarsteffens
Frequent Visitor
9 years ago
Solved

Creating a custom column over 2 columns from 2 different tables

Hello all,   I'm trying to make a custom column in one table with conditions over columns in that table and another table. However when I try to do that and give the tables name it says that it can...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Joshmarsteffens,

     

    You can try to use below formula, I test with your sample file and it works on my side.

     

    Check = 
var result= Lookupvalue(Records[Textuele Waarde],Records[Kavel ID],Kavel[Kavel ID ],Records[Kenmerk nummer],2016007)
return
IF(result<>blank(),result/100,0)

     

     

    Reards,

    Xiaoxin Sheng