First Value

[DavidB023]

Hi everybody !

I just need to create a column in a table from the first value of another column from many tables.

In fact, I used Switch function but I have some difficulties with the first value selection. I try MAX but I have figures and texts in the same column. I try  FIRSTNONBLANK but when I actualize my data, function don't take the first value but the second...

Best regards

David

[Anonymous]

@DavidB023,

Please share dummy data of your tables and post expected result here.

Regards,
Lydia