5 Replies Latest reply: Jun 18, 2012 2:39 PM by Jose Tos RSS

    Count Cancel Date



      I'm tyring to create a column either through set analysis or on import (would like to have both solutions) where I add a counter indicating whether a user has cancelled. Here's a sample of my data:

      Screen shot 2012-06-13 at 10.10.54 PM.png


      On import, I tried the following, however, this returned a 1 for every record.:


      If(isnull([Cancelation Date]),0,1) as HasCancel,


      Using set analysis, I tried the following, but this doesn't work either.:


      sum(if([Cancelation Date] = (">0"),1,0))


      Again, the goal is to count or sum whether a user has canceled. If anyone has any insight on a solution on import and using set analysis that would be great.


      Thanks in advance!