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

Joshmarsteffens's avatar
Joshmarsteffens
Frequent Visitor
9 years ago

Hi Anonymous,

 

You're right i overlooked one i did change the kavel ID to the name of mine but i forgot to change textuele waarde... 

The syntax is without errors now, However im not getting the right results. its giving me 0 or blank() value's.

 

I'll try to look where this is going wrong and tell you what happend. 

 

Thank you so much for all the hulp and quick responses!

 

Kind regards,

 

Joshmar Steffens

Joshmarsteffens's avatar
Joshmarsteffens
Frequent Visitor
9 years ago

Hi Anonymous,

 

Found the problem, it was the if statement at the end. for some reason it did not accept the <> (is not) indication so i just wrote it completely if(result = BLANK(); 0; result/100). This worked.

 

once again thank you so much for your time and your help!

 

Regards,

 

Joshmar Steffens