Forum Stats

  • 3,686,902 Users
  • 61,168 Discussions
  • 206,740 Comments

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.

Highlight result if less than 100% (Case When)

edited May 17, 2022 3:11PM in Ask A Guru 4 comments

I've got this formula (Text) in a Saved Pricing Search: ROUND(({unitprice}/NULLIF({item.currentstandardcost},0)),4)

Now I want to change the color of the result if it's less than 100%. So i'm trying to create a Case WHEN statement.

The closest I got was the following:

Case WHEN ({unitprice}/NULLIF({item.currentstandardcost},0)*100) < '100'

THEN '<p style="color:#FF0000;"> ROUND(({unitprice}/NULLIF({item.currentstandardcost},0)*100),4) '

ELSE ' ROUND(({unitprice}/NULLIF({item.currentstandardcost},0)*100),4) '

END

But when I use the above formula, I get a weird result. Instead of numbers I get the following:

ROUND(((round(decode(invtitemprice.kpricetype,-1,(select rabsoluteprice from customeritempricing where kitem=invtitemprice.kitem and kcustomer=entity.nkey),invtitemprice.runitprice)*nvl(saleunit.mconversionrate,1),5))/NULLIF((get_total_standard_cost(it_itemlocationmap.kitem, it_itemlocationmap.klocation)),0)*100),4)

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