I can't share the actual data because its confidential, but please see excel file with a simple example of the data I have. All I am trying to do is to get the total number of stores On Target in terms of sales and place that number in a Key Value. Store - Name of the store Actual Sales - Sales that have been carried out Target Sales - The target sales amount or the day Target Ratio = Actual Sales/Target Sales Target Reached - This is a calculated item that I created to return "On Target" or "Not On Target" depending if the ratio is >= 1 Thanks
... View more