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

Hello Anonymous,

 

Here is an example of the data I am using.

Kavel IDKenmerk nummerTextuele Waarde
11122016001123
11122016005423
11122016006572
111220160077,69
111220160081892
111220160092031
111220160102241
111220160112016
11212016001123
11212016005423
11212016006572
112120160075,21
112120160081892
112120160092031
112120160102241
112120160112016
11422016001123
11422016005423
11422016006572
114220160078,51
114220160081892
114220160092031
114220160102241
114220160112016
12322016001123
12322016005423
12322016006572
123220160072,1
123220160081892
123220160092031
123220160102241
123220160112016
12452016001123
12452016005423
12452016006572
124520160079,21
124520160081892
124520160092031
124520160102241
124520160112016
Kavel ID Calculated Column
1112 
1121 
1142 
1232 
1245 

 

Kind regards,

 

Joshmar Steffens

Anonymous's avatar
Anonymous
Not applicable
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,

     

    With me it doesn't give any underlined errors anymore however it does say that the syntax for '.2016007' is incorrect.

    I fixed the above but it gives me the warning that the Record[Kavel ID] cannot be found or may not be used in this expression.

     

    Regards,

     

    joshmar Steffens

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Joshmarsteffens,

       

      Records is the first table(table with three columns), kavel is the second, you should use your table name to replace them.


      Regards,

      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