[Justin Xarisma]

I have made a formula in a search that works the way I want but when I attempt to get the same out of a report I fail miserably.

Is it possible to do similar equations from searches in reports? Let me state that I am no expert at reports and I even try to stay away from them because I feel searches are much easier to deal with.

Here is an example of an formula

CASE WHEN {customermain.custentity2} IS NOT NULL THEN {customermain.custentity2} WHEN {customermain.parent} IS NOT NULL THEN {customermain.parent} ELSE {name} END

it looks for the customer group first, then to see if there is a parent company, and if neither applies, then it goes to the customer name.

If some one could help me get this on a report it would make my life a lot easier. Thanks
This is a cached copy. Click here to see the original post.

[trimblee]

RE: Formulas in Reports

Can’t do it in a report. Formulas in reports don’t go beyond basic arithmetic.

Evan

[Justin Xarisma]

That is what I thought no matter how much I do not want it to be true. Thanks

[The Wizard of Oz]

RE: Formulas in Reports

Originally posted by trimblee

View Post

Can’t do it in a report. Formulas in reports don’t go beyond basic arithmetic.

Evan

Even this statement is a stretch! Report formulas are atrocious!

[Justin Xarisma]

is there a reason that this can not be changed?

[trimblee]

RE: Formulas in Reports

That’s kind of a philosophical question.

The simple answer is no, there’s no reason beyond the mere fact that it’s impossible.

Obviously, NetSuite could redo the reporting engine, and make stuff like this possible. And as it happens, that is what I’ve heard is happening. It was discussed a little at SuiteWorld this year, not sure about ETA.

Evan

[The Wizard of Oz]

RE: Formulas in Reports

I think it’s scheduled for the 2215.2 release.

[rnedelkow]

You can also vote for Enhancement 76804 : Formulas – Add search-like formula capabilities (SQL) to report builder (report customization) with no limit on elements or operators.

Thanks,

[Justin Xarisma]

Thanks for all the responses. I will be voting on that one for sure.

[Author]

Posts