Forum Discussion

edavila's avatar
edavila
Icon for Helper II rankHelper II
9 years ago

Averages

is there a way to get the average percentage of these 3 columns in the totals, I dont seem to find a way, I will like to have an average of the YOY growth %, dont know why in the total is getting the...
Show and Tell
erik_tarnvik's avatar
erik_tarnvik
Icon for Solution Specialist rankSolution Specialist
9 years ago

There is no way to tell unless you provide the formulas and data you used to arrive at this result.

  • edavila's avatar
    edavila
    Icon for Helper II rankHelper II
    9 years ago

    What exactly do you need to see

     

    thanks for your help

    • erik_tarnvik's avatar
      erik_tarnvik
      Icon for Solution Specialist rankSolution Specialist
      9 years ago

      What do the table(s) that are the source for your results look like? And, what formula did you use for the growth calculations?

      • edavila's avatar
        edavila
        Icon for Helper II rankHelper II
        9 years ago

        this is the formula for the cases YOY

        YOY Cs Growth % = divide([YTD Cases] - [YTD Cases Prev], [YTD Cases Prev],0)

         

        for sales

        YoY Growth % = DIVIDE([YTD Sales] - [YTD Sales Prev], [YTD Sales Prev],0)

         

        does this help