CR 10.2 - Error in formula???

[blakemckenna]

I have a formula in which I'm getting the following error

"A field is required here"

on the highlighted code.

Dim dblDifference as Double

dblDifference = CDbl({@Difference})

formula = Sum(dblDifference)

[blakemckenna]

Anyone have an idea what's causing this?

thanks,

[brucevde]

Think about it.

If @Difference were = 1
dblDifference would = 1
Sum(dblDifference) would also = 1, so what is the point.

If you are just trying to Sum the @Difference formula.

Formula = Sum(CDBL({@Difference}))

The above still may cause an error depending on the actual @Difference formula.

[blakemckenna]

I already tried your suggestion Bruce and it gave me the same error msg. But here is the formula for @Difference:

Sum ({tblReport.invoicedAmt}, {tblReport.custNO}) - Sum ({tblReport.advProdTotCost}, {tblReport.custNO})

Both tblReport.invoicedAmt and tblReport.advProdTotCost are defined as Integers.