Hi Toby. In your formula, it looks like you are attempting to convert a string to an integer, and that will not work for those values. You could use something like this as a formula:
SUM(IF [Receipt]==“Yes” THEN 1 ELSE 0 END)
or if you only need the “Yes” values in your viz, you could add [Receipt] to the Filters pane and filter on the “Yes” value.
Ow ok i had to change the " to ' but it worked a treat thanks.
I have only ever done and this is recently some stuff in access so trying to learn the nuances of calculation, I will have to research more for a guide of sorts.
So if I was trying to do something like below is this correct thinking?
SUM(IF STARTSWITH([AppealID],"CDM") AND [Amount] >= 20 Then 1 else 0 End
So count of records when appeal starts with CDM and amount is equal or bigger then 20
Where AppealID is a string
And AMount is a number
Thanks for the help Brent.
Actually had time to check and it does