or how to create a search or report to get that?

@Kmullervy You're going to have to do some playing around, but here's some resources to get started: SuiteAnswer Id: 37724 (I like this one best. I used it for a sort-of similar formula.) SuiteAnswer Id: 75217 SuiteAnswer Id: 25112

Thank you for this! Looks very helpful.

Np. Yeah, it was a sticky one. I still had to do some work, but once I found those articles it went a lot quicker.

I have never seen that big formula, formula in sa 25112

Ya, is pretty crazy. TBH, I never really considered/looked into that one because it was so long. 😅

Lol yeah if it doesn’t work I would never be able to figure out where the mistake is

Yeah, seriously need some kind of debugger for formulas. I wrote one formula myself (for a different thing) that is ~1 page long, which I had a missing parentheses in. That was a terrible 2 hours of my life.

Wow!! But sql does come handy, I need to learn that

"SQL Expressions" SuiteAnswer Id: 10101 is pretty much all you need. Maybe google "Oracle Database SQL Reference" if there's a specific function you really need or that you're having trouble understanding

Aah nice thanks!!