"Number is required here" error in valid multiplication formula

[JellyDude]

I am receiving the error "A Number is required here" in a formula that is doing simple multiplication of 2 formula fields and a parameter field.

Example: (formaula_1 * para_2 * formula_3)

The third formula field will receive the "A Number is required here error". Troubleshooting to date:

1. Changed the suspect formula field to an value of 1 and the error went away, i.e. (formula_1 * para_2 * 1).

2. Changed the suspect formula field to a different formula field and the error persisted with the new field.
(formula_1 * formula2) -> (formula_1 * para_2 * formula_5).

3. Created a new formula with just two formula fields and the error occured again. (formala_1 and formula_3)

4. Tried defining local variables in the formula and using the local variable in the equation. Error re-occured.

5. Loaded SP2 for Developer 8.5 and error re-occured.

Basically I can move the formula fields around inside the equation however I want and re-create the error. The only common link between the equations is the use of one formula field that seems to start the error. Once the error has started in a equation, then it persists even if the offending formula field is removed.

The offending formula field comes from a subreport run in Page Header b and is used in the Report footer.

Thanks for your help!!

 

[vidru]

Why don't you post your formulas so we can have a look.
Espescially the one(s) that are generating the errors (like formula_3 in your example above).

-dave

 

[synapsevampire]

<chuckling>

This is like a bad version of an old logic test:

Sounds like Formula 3 and Formula 5 are not numeric.

Try adding val() around your formula in 3 (or 5 for that matter).

Or perhaps you have a Currency field.

-k

 

[Ngolem]

yes SV...I think it called a shell game...find the pea.

JellyDude - show us the formulas...the answer will be obvious when we see them

Jim Broadbent

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

 

[JellyDude]

Folks,

By popular demand, here is the fix attempt using a local variable:

CurrencyVar be_cv_tmp1 := {@be_vol_nes_cov_after_cls_alloc} * {?be_reqd_yield} * {@be_avg_loan};

The error shows up with the cursor immediately in front of {@be_avg_loan}.

I tried ccur() and it did not help.

Thanks again for your help!

 

[Ngolem]

Show us the formulas!! we'll believe there is a problem...but we cannot solve it til we see what the formulas are!!!

Jim Broadbent

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