Join Slack
Powered by
This search is giving all open invoices, some invo...
# general
r
raghav
06/15/2022, 8:38 AM
This search is giving all open invoices, some invoices are partially paid and I would like to filter them out. Could someone please provide a solution for it.
m
michoel
06/15/2022, 9:26 AM
Compare amount to amount remaining in a formula
r
raghav
06/16/2022, 3:55 AM
can you help with the formula please 😅
m
michoel
06/16/2022, 5:16 AM
Untested but probably something like
CASE WHEN {amountremaining} = {amount} THEN 1 END
is equal to 1
👍 1
r
raghav
06/16/2022, 5:18 AM
Will check thank you.
4
Views
Open in Slack
Previous
Next