Forum Discussion
Query and Calculated Column (Date and Time as well) Help
Hi, I have a series of transactions as a data feed from a time and cost programme. What I would like to do is to take the data on a given day and allocate a flag to the 'live' transactions at th...
Hi warrenpoh,
Do you have a time table in your data model? Maybe you can use Lookupvalue to achieve this requirement. It returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…)
Please provid us the details table structure of your tables and some sample data of them, so that we can make furhter analysis.
Regards,
Charlie Liao