Forum Discussion
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...
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
BTW there is probably a way to get the totals to come out the way you want, but you would have to share the definition of all measures used in your definitions above. And any measure used in those measures and so on.