AnsweredAssumed Answered

Calculation Help

Question asked by sccardais on Feb 10, 2015
Latest reply on Feb 12, 2015 by sccardais

Title

Calculation Help

Post

I have a table of monthly performance metrics that includes the following fields:

         
  • Reporting_Period (Date)
  •      
  • Metric (value list of 5 possible Metrics including Revenue, Free_Trials, New Customers, Cancellations and Support Requests)
  •      
  • Value: (number)
  •      
  • Product_Version (value list of 10 possible products)

I am trying to calculate "ConversionRate" by dividing the number of NewCustomers each Reporting_Period by the number of Free_Trials each Reporting_Period..

Because the metrics are stored as attributes rather than separate fields, I'm having a hard time figuring out how to calculate the ConversionRate for each Reporting period. Is there a way to do this with my current structure or will I need to move the values for each Metric into separate fields? e.g. each record has separate fields for Revenue, New Customers, etc.

Outcomes