I have two formula fields in saved search results ...
# general
m
I have two formula fields in saved search results using case statements. I’d like to make a third field that subtracts them, and a forth field that divides them against each other to show a percentage. Is there any way to reference those columns in my new third formula? Or do I need to repeat the formula - second formula to get the results? (Seems like that would require more work by NetSuite slowing down the saved search if it’s built that way)
k
Have to repeat the formulas
m
😞 Ok, thanks
k
also - should probably include appropriate "null ifs" to prevent error
finally - if you are doing this in a summary search - you might have to do additional logic to get it to calculate correctly
m
thats what the docs seemed to be pointing to, but was hoping for another option.
Thanks Kevin