Hi there
I need some help please i have two tables one with records of visits at the same client or different and another table with customer information ( phone, name, email,stock).
i need to extract the last information of the stock of the first table and show in the second table corresponding the company_id
I already made this formula so that it gives me the first registration of the stock and I want the last
LOOKUP([_THISROW].[Company_ID],โContactos equipa Piscaโ,โID do Piscaโ,โStock na empresaโ)
Can you help? please
Solved! Go to Solution.
Hi Steve i put this way and crash the app
MAXROW(
โContactos equipa Piscaโ,
โ_ROWNUMBERโ,
([_THISROW].[Company_ID] = [ID do Pisca])
)
the โContactos equipa Piscaโ its the first table where is the data to extract
In what way did the app crash? Is there an error message? If so, please post a screenshot.
They crash because of the time out
Can i do this with dereference ? to make the app more simple and because of the time of sync
Steve thanks for your help now gives me this error.
The expression is valid but its result type โRefโ is not one of the expected types: Number
Please post a screenshot of the configuration screen of the column that uses this expression.
Thanks Steve for the help i had a bad table reference
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |