Forum Discussion
Latest Invoice Amount - Iternation
Hello, I Have a table of invoices to that was submitted to the health insurance company that looks similar to this: Invoice No. Mode (1- submission, 2- Resubmissition, 3- Correction) Amo...
Mamoun_issa , Try with invoice no in visual
lastnonblankvalue(table[mode], max(Table[amount]))
Thank you, but this will get me the max, assuming some invoices became less
Mamoun_issa , find the file attached.