Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

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?

 

Need Help
  • TomMartens's avatar
    TomMartens
    1 year ago

    Hey Anonymous ,

    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

3 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    1 year ago

    Hey Anonymous ,

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.