Formula yields "0", should be "12"

steven.nienaber105336

Not sure why this is not calculating?

It seems it doesn't like that the numbers derive from a formula as when I change the number to a value, it calculates.

Thank you!

hollyconradsmith

@steven.nienaber105336,

Try adding VALUE( to your formula?

SUM(Value(formula):Value(formula)) ?

steven.nienaber105336

=SUM(VALUE([Formula - Work Experience 18-19]@row:[Formula - Work Experience 21-22]@row))

Gives me "INVALID DATA TYPE"

hollyconradsmith

Hi @steven.nienaber105336

I believe you would have to separate each column into its own value formula:

SUM(VALUE([Formula - Work Experience 18-19]@row):VALUE([Formula - Work Experience 21-22]@row))

Alternatively, you could do =VALUE([Formula - Work Experience 18-19]@row)+VALUE([Formula - Work Experience 21-22]@row)