to do it in a saved search it would look something like `SUM NetSuite Professionals #suiteanalytics

to do it in a saved search it would look something...

KevinJ of Kansas

06/30/2020, 5:11 PM

to do it in a saved search it would look something like

SUM(decode({account},'Internal ID acccount1',{amount},0)/nullif(sum((decode({account},'internalID account2',{amount},0),0)

MaryPeace

06/30/2020, 6:36 PM

this didn't work

KevinJ of Kansas

06/30/2020, 7:45 PM

well, it's just an example

KevinJ of Kansas

06/30/2020, 7:45 PM

of how I'd go about solving.

KevinJ of Kansas

06/30/2020, 7:45 PM

I didn't actually proof it out.