This content has been marked as final.
Show 3 replies

Re: How to calculate the Avg of fully used Tariffs..??
Vishwarath Nagaraju Apr 16, 2018 11:28 AM (in response to dhasharadh goud)May be this?
= Sum(NUM_OF_FULLY_CONSUMED * NUM_OF_DAYS)
/SUM(NUM_OF_DAYS)

Re: How to calculate the Avg of fully used Tariffs..??
dhasharadh goud Apr 16, 2018 12:06 PM (in response to Vishwarath Nagaraju)thanks Nagaraju,
what is the wrong in the below expression :
= Sum({<TYPE={LDP} and NUM_OF_FULLY_CONSUMED<>0 >}AVG_DAYS_SUM) / Sum({<TYPE={LDP} and NUM_OF_FULLY_CONSUMED<>0>}NUM_OF_DAYS)

Re: How to calculate the Avg of fully used Tariffs..??
Vishwarath Nagaraju Apr 16, 2018 12:25 PM (in response to dhasharadh goud)Try this?
= Sum({< TYPE={'LDP'}, NUM_OF_FULLY_CONSUMED = {'<>0'} >} AVG_DAYS_SUM) /
Sum(TOTAL {< TYPE={'LDP'}, NUM_OF_FULLY_CONSUMED = {'<>0'} >} NUM_OF_DAYS)OR
= Sum({< TYPE={'LDP'}, NUM_OF_FULLY_CONSUMED = {0} >} AVG_DAYS_SUM) /
Sum(TOTAL {< TYPE={'LDP'}, NUM_OF_FULLY_CONSUMED = {0} >} NUM_OF_DAYS)

