topic Re: Average Calculation in smartforms without considering zero values in columns in Application Development and Automation Discussions

Average Calculation in smartforms without considering zero values in columns

satvik_panchal — Wed, 06 Feb 2013 11:11:34 GMT

Dear Experts,

I have developed a smartform. In that, I m facing one problem in calculating the average values of all columns without considering the zero values in columns.

The coding which I have done is given below:

CLEAR count.

LOOP AT it_final1 INTO wa_final1.

if ( wa_final1-difference9 ne '0.00'

wa_final1-difference8 ne '0.00'

wa_final1-difference7 ne '0.00'

wa_final1-difference6 ne '0.00'

wa_final1-difference5 ne '0.00'

wa_final1-difference4 ne '0.00'

wa_final1-difference3 ne '0.00' ).

count = count + 1.

endif.

wa_final1-avg_diff = wa_final1-diff_total / count.

MODIFY it_final1 FROM wa_final1.

ENDLOOP.

But I m not able to get the correct average value.

Can anybody suggest me where i m wrong.

Thanks and Regards,

Satvik

Re: Average Calculation in smartforms without considering zero values in columns

Former Member — Wed, 06 Feb 2013 11:28:50 GMT

HI,

The logic should be like this,

Inside loop,

clear count.

if ( wa_final1-difference9 ne '0.00' )

count = count +1.

elseif (wa_final1-difference8 ne '0.00' )

count = count +1.

elseif (wa_final1-difference7 ne '0.00')

count = count +1.

elseif (wa_final1-difference6 ne '0.00' )

count = count +1.

elseif (wa_final1-difference5 ne '0.00' )

count = count +1.

elseif (wa_final1-difference4 ne '0.00' )

count = count +1.

elseif (wa_final1-difference3 ne '0.00' ).

count = count +1.

endif.

Now calculate the average from the count.

Thanks,

Ben

Re: Average Calculation in smartforms without considering zero values in columns

Former Member — Wed, 06 Feb 2013 11:34:46 GMT

HI Satvik,

You have to increase count for every column.

I think following code will work!

LOOP AT it_final1 INTO wa_final1.

CLEAR count.

if wa_final1-difference9 <> '0.00'

count = count+1.

endif.

if wa_final1-difference8 <> '0.00'

count = count+1.

endif.

if wa_final1-difference7 <> '0.00'

count = count+1.

endif.

if count > 0.

wa_final1-avg_diff = wa_final1-diff_total / count.

MODIFY it_final1 FROM wa_final1.

endif.

ENDLOOP.

Thanks,

Sivaji.

Re: Average Calculation in smartforms without considering zero values in columns

satvik_panchal — Wed, 06 Feb 2013 11:49:42 GMT

Thanks Sivaji.