1 of 1 people found this helpful
I believe the issue is that the fields being used in the calculation are not being aggregated. Change the formula to look like the following:
If this doesn't help, would you be able to post the workbook (twbx file)?
Thanks so much for that - it worked.
Incidentally, this whole incident makes me realise that whilst I completely get and understand the drag and drop portion of Tableau - am much weaker on calculated fields. Which is a shame as it's probably one of the most powerful tools available in the package.
Are there are resources kicking around on the net that'll help me build up some calculated field knowledge in a step by step manner?
Glad I could help. The best resources for learning how to write calculated fields are probably the forums and the Knowledge Base, but most of all practice!