AnsweredAssumed Answered

Calculate one field based on another

Question asked by SchoolData on Jul 5, 2013
Latest reply on Jul 6, 2013 by davidanders

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.

Outcomes