Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Adding 2 formula columns in saved search
Hi,
I have created 2 columns using Formula(Currency) option and have the desired results in 2 columns.
Howver I now want to add these 2 columns together and every combination I have tried fails
My 2 Formula(Currency) Fields are
case when {type} = 'Credit Memo' then {amount} else null end
AND
case when {type} = 'Invoice' then -{amount} else null end
Can anyone help on 2 points :-
1. Why using (case when {type} = 'Credit Memo' then {amount} else null end)+(case when {type} = 'Invoice' then {amount} else null end) does not work? Is it because I am adding a currency amount to a null and if so what is solution
0