Forum Discussion

mxblaise's avatar
mxblaise
Regular Visitor
8 years ago
Solved

Calculated column from two different tables

Hello,   There are several post about this topic but I really don't get the logic. I have two tables feeded by two different files, so two corresponding tables.   OperationsTable : Serial O...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I believe that this will work:

     

    Column = DATEDIFF([NDT date],MAXX(FILTER(RELATEDTABLE(OperationsTable),[Operation]="Injection"),[Operation date]),DAY)

    What this is doing:

     

    RELATEDTABLE - brings back all related records from OperationsTable

     

    FILTER - Filters the results from RELATEDTABLE to just those whose [Operation] is "Injection"

     

    MAXX - Grabs the MAX out of a table, could use any aggregation

     

    DATEDIFF takes the difference in days between the two dates

Martin456's avatar
Martin456
New Member
7 years ago

Hey,

 

I have similar problem and this solution doesn't work as I am getting and error of too many arguments. I have table A with serial number and pending status on a certain date. Second table B with serial number completed status on a certain date and would like to count how many days have passed between pending and completed status.

 

Thanks a lot in advance.

Martin456's avatar
Martin456
New Member
7 years ago

Found out I was missing some parenthesis. The formula works just fine.