Your workbook is prompting for me to connect to your Tableau Server, so I can't exactly test this, but my suspicion is that you want to aggregate Adds in your calculated field:
IF SUM([Adds])>0 THEN SUM([Adds]) ELSE 0 END
The workbook is still connected to the server. So we aren't able to open it. could you change the data to extracts or just make some dummy data?
Yes i want to aggregate the Adds in my Calculated field.
Okay, the adjustment I showed above should correct the problem.
Give it a try. If it solves your issue, then please be so kind as to mark my response as the "correct answer" so we can close this thread and others can quickly find answers to similar problems in the future. Thanks!
Thanks Ken, it worked and also understood the reason why it dint worked .