Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.

Help! I keep getting not a valid expression.

edited Jan 3, 2020 12:29AM in Search / Reporting 1 comment

Below is my expression.  I think I have an issue with parenthesis, but I am not sure.  Any help would be great.


COALESCE(GREATEST({custitemamzaspd2wk}, custitemamzaspd4wk}),0)/COALESCE(GREATEST({custitem_aspd2weektest},{custitem_aspd4weektest}),1)*({custitempreferredstocklevel}+{locationquantitybackordered}+({leadtime}*GREATEST({custitem_aspd2weektest},{custitem_aspd4weektest}))-GREATEST({locationquantityavailable},{custitem_reorderpoint})+GREATEST({custitem_reorderpoint}-{locationquantityavailable},0))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders