7 Replies Latest reply on Feb 21, 2012 12:13 AM by Gareth Jones

    CNT on a calculated text column?

    Gareth Jones

      Hi All

      I am trying to do the following, and I hope it can be done!

       

      My data:

       

      Customer NumberMonth 1Month 2Month 3Is Active?
      123456789000Inactive
      126457897000Inactive
      326598741645Active
      666666666310Active

       

      Basically, in a single table, I have Customer Number, Month 1, 2, 3.  I am then using a calculation of IF (SUM [Month 1], [Month 2], [Month 3]) >0 THEN "Active" ELSE "Inactive" END

       

      And I am then using the new calculated field as if it was a column.  And it works, I can make the data look like this:

       

      Customer NumberIs Active
      123456789Inactive
      126457897Inactive
      326598741Active
      666666666Active

       

      However I am really needing to view the data like this:

       



      Active2
      Inactive2

       

      So either I'm really not that great at putting these into the right shelf, or am I going about this wrong?

       

      I need this sort of calculation on quite a few other columns to produce these "calculated text fields" so any help would be GREATLY appreciated!

       

      Thanks

      Gareth