Add two fields show result as negative based on selection of a dropdown list

Question

Hello,

I am trying to add my actual expenses and other expenses, with the result being either negative or positive based on a drop-down list selection.

The "PCard/Yes" option is in the dropdown list, and if this option is chosen, I need the result to show as negative.

try67 · Answer

Set the Export Value of that item as -1 (and the others as 1) and then multiply the sum by that field.

Sign up