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

    Count Cancel Date

      Hi,

       

      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!

       

      Matt