Hi , need urgent help in calculating the avg for fully consumed passes.
my report willl show information about usage of the tariff plans like how they consumed, fully consumed, partially consumed, unused etc..
for all the above am calcuating at script level only excpet for avg, for avg the formula we have to use is :
for avg number of passes which are fully consumed - we have to use the below formula given by the business, when i write the same in the script and excute it is not giving the correct avg.. in general how we calculate the average for these cases.
= (NUM_OF_FULLY_CONSUMED * NUM_DAYS) / SUM(NUM_DAYS) WHERE NUM_OF_FULLY_CONSUMED != 0
Now am in great trouble that where to use this . .. please help me whether i have to calculate the avg at script level or in the UI, and what is the way to do it, thanks in advance.
