Error on sum formula

[Hueby]

Why would I get a error "A field is required here" under my (CDbl({spLaborAct;1.Hourswrk}) part in the following code?

sum(CDbl({spLaborAct;1.Hourswrk}), {spLaborAct;1.purchord})

Do I not have my code setup right here?

 

[lbass]

Try this in two steps:

//{@HrsWk}:
cdbl({spLaborAct;1.Hourswrk})

//{@tothrs}:
sum({@HrsWk},{spLaborAct;1.purchord})

-LB

 

[Hueby]

Now I have a "the remaining text does appear to be part of the formula..." highlighted on the 'sum({@HrsWk},{spLaborAct;1.purchord})' code.

Can I ask what is with the //{@HrsWk}: and //{@tothrs}: comments? I'm not fully understanding this. Thanks lbass!

 

[synapsevampire]

LB is suggesting 2 different formulas, not one with 2 formulas within and comments.

Create the first, and base the second on the first.

-k

 

[lbass]

The commented lines were just names I gave to the two different formulas, so that you could see I was using the first formula in the second formula.

-LB