1 Reply Latest reply on Jul 6, 2013 10:07 AM by davidanders

    Calculate one field based on another

    SchoolData

      Title

      Calculate one field based on another

      Post

           I have a table "ASSESS" with about 1,200 records in it.

           I need to know the count of the records that have a "1" in ASSESS::tag and "PRO" in ASSESS::level_pro.

           Ultimately, I am trying to calculate the percentage of the records that have a "1" in ASSESS::tag and "PRO" in ASSESS::level_pro and the percentage of records that have "0" in ASSESS::tag and "PRO" in ASSESS::level_pro.