Formula to get the tax amount for the total invoice even if an item is excluded from the saved search

AI generated answer (using internal Slack threads):

Based on the conversations, to get the tax amount for the total invoice even if an item is excluded from the saved search, you can use a formula in your saved search. The formula would be

{taxtotal} / NVL( NULLIF( {netamountnotax} , 0), 1)

. This formula will handle both situations where the net amount not tax is either 0 or NULL. Here's how it works: -

NULLIF({netamountnotax}, 0)

will return NULL if the net amount not tax is 0. -

NVL(NULLIF({netamountnotax}, 0), 1)

will return 1 if the first expression is NULL. -

{taxtotal} / NVL(NULLIF({netamountnotax}, 0), 1)

will divide the tax total by the result of the NVL function. If the net amount not tax is 0 or NULL, it will divide by 1, effectively returning the tax total. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******