Formula within a formula

[Hypermommy]

Hi all...

I've inherited a tricky little report and am trying to simplify the formula so I can comprehend the report. Several times in this one formula I've noticed code like:

if (assigned_to = "group 1" or assigned_to = "group 2&quot then

do something.

Of course, in the real report the field names are larger and the name of the groups are larger, thus making it very hard to read. I'd like to replace that with something like:

if (is_theirs()) then do something

where is_theirs() is a User Defined formula that returns a true or a false.

Can I do this? How? Thanks.

-= Hypermommy =-

 

[Ngolem]

you can create a formula and refer to it without placing it on the report.

As far as your situation in concerned I would need the original formula to advise whether this is the best way or not...it may be possible to simplfy yhe formula without doing this.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[Hypermommy]

Thanks! I was just getting back online to say I'd figured out how to do it. I may even learn to actually like this tool

-= Hypermommy =-