millhouse123
Active Member
- Joined
- Aug 22, 2006
- Messages
- 335
I have a Dax formula that is not working as expected and I need help figuring out why.
here is the formula:=
CALCULATE(SUM('2016 Transactions'[Book Value]))
I get an error that sum cannot work on a string which makes sense except that I have formatted the data as decimal. How do I force that field to be numeric instead of string?
Thanks
here is the formula:=
CALCULATE(SUM('2016 Transactions'[Book Value]))
I get an error that sum cannot work on a string which makes sense except that I have formatted the data as decimal. How do I force that field to be numeric instead of string?
Thanks