Forum Discussion
Date before from another table
Hello,
Can someone help me with this?
I have two table without any relationsship.
I need a calculated colum in the PayTable from the CallsTable.
The calculation rule is the first date from the CallsTable but not equal.
Greetz,
Ronald
Hi Ronald123,
To be general, are date in column Table Calls[CallDate] unique? To use lookupvalue(), or other similar function like related(), you should build a one-many relationship between the two tables, then use column in one-side as a filter condition to achieve the value you want.
Regards,
Jimmy Tao
1 Reply
Hi Ronald123,
To be general, are date in column Table Calls[CallDate] unique? To use lookupvalue(), or other similar function like related(), you should build a one-many relationship between the two tables, then use column in one-side as a filter condition to achieve the value you want.
Regards,
Jimmy Tao