Odd "Sum is not a function" error in my formula

[lauriemclolo]

For the first formula, I am getting the error "Sum is not a function" and "Cannot find name 'sum  "

But the second formula appears to be fine.  Both are whole number fields.  I am using direct query.  

First Formula:  Ttl $ Rewards Issued        = sum(v_flt_monthly_rew_balance_dtl2_combined[rewards_issued_points])*.01

Second Formula:  Ttl $ Rewards Expired = sum(v_flt_monthly_rew_balance_dtl2_combined[rewards_expired_points])*.01

Any ideas?

[TomMartens]

This is what I was talking about:

[lauriemclolo]

Hello @TomMartens .  I tried to look up the difference but couldn't find it.  Would you mind telling me what I hit to accidentally "develop" a measure, and where I can look to discover the difference?  Thank you again.

[TomMartens · Accepted solution]

Hey @lauriemclolo ,

Maybe the first formula is used to create a measure, while the second formula is trying to develop a measure.
Check the 'icon' next to the formula in the data pane.

Hopefully, this helps to tackle your challenge.

Regards,
Tom