Forum Discussion
find first value
I have the following two tables: Order and OrdLn I would like to find OrdLn[Price] where OrdLn[OrdNo] = Order[IDBakssystem] and OrdLn[ProdNo] = "TS-L" and store it in an calculated column TS-L in t...
This has been solved by correcting the data in the database, eradicationg the original problem.
Thank you very much for your assistance!
PattemManohar
Community Champion
Community ChampionAnonymous Please post the sample test data (that can be copied easily) and expected output to suggest an accurate solution.
OK! :-)
I think I solved it by creating two Columns:
Value_IDBaksystem = IFERROR(VALUE( Ordre[IdBaksystem] );0)
And then
TS-L =
CALCULATE (
FIRSTNONBLANK( OrdLn[Price] ; 1 );
FILTER (
OrdLn;
OrdLn[ProdNo] = "TS-L" && OrdLn[OrdNo] = Ordre[Value_IDBaksystem]
)
)