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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
GRNI formulas in a saved search vs analytics
Anyone know what the equivalent formula for this would be in Analytics?
It's one part of the formulas from SuiteAnswers 65324 workaround for a GRNI report/saved search.
This brings up the bills in a GRNI report, and works fine in the saved search:
- Saved Search formula
case when {createdfrom.type} = 'Purchase Order' and {type} = 'Bill' then {amount} else 0 end
This doesn't seem to work in Analytics
case when {transactionlines.createdfrom#display} = 'Purchase Order' and {type#display} = 'Bill' then {foreigntotal} else 0 end
Any ideas? Everything else works bar this.. The remaining formulas are these..
Thanks,
0