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!
Growth Rate
I am trying to create a growth rate search using a formula (present-past)/past. i was successful in using a decode function to get the result for past and present, but when i try to preform the final calculation i am getting a divide by zero error. here is the formula
(CASE TO_CHAR({trandate},'YYYY') WHEN '2017' THEN decode(to_char({trandate},'YYYY'),2017,{quantity},0) ELSE 0 end - CASE TO_CHAR({trandate},'YYYY') WHEN '2018' THEN decode(to_char({trandate},'YYYY'),2018,{quantity},0) ELSE 0 END)/CASE TO_CHAR({trandate},'YYYY') WHEN '2018' THEN decode(to_char({trandate},'YYYY'),2018,{quantity},0) ELSE 0 END
0