Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vishalgoud
Contributor

avg issue, not matching with Sql result

Hi , need urgent help in calculating the avg for fully consumed passes.

my report willl show information about usage of the data plans. like 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 :

= (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 and which form i have 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.