is this correct expression...??

[vishalgoud]

Hi all,

can anybody evaluate the below expression please. i want to calculate Sum(NUM_OF_DAYS)/sum(NUM_OF_FULLY_CONSUMED) when NUM_OF_FULLY_CONSUMED is not equal to Zero and type is GDP

Sum({<TYPE={GDP},NUM_OF_FULLY_CONSUMED =-0>}NUM_OF_DAYS)/Sum({<TYPE={GDP},NUM_OF_FULLY_CONSUMED =-0>}NUM_OF_FULLY_CONSUMED)

[Chanty4u]

try

Sum({<TYPE={'GDP'},NUM_OF_FULLY_CONSUMED- ={'*'}>}NUM_OF_DAYS)/Sum({<TYPE={'GDP'},NUM_OF_FULLY_CONSUMED - ={'*'}>}NUM_OF_FULLY_CONSUMED)

[sunny_talwar]

May be this

Sum({<TYPE={GDP}, NUM_OF_FULLY_CONSUMED -= {'0'}>}NUM_OF_DAYS)/Sum({<TYPE={GDP}, NUM_OF_FULLY_CONSUMED -= {'0'}>}NUM_OF_FULLY_CONSUMED)