Condition in AVG

Hi guys,
I have groupfooter in my report. There is memotext [AVG(<DSSumar."Doba">)] in this groupfooter. But some values are 0. Is it possible to insert condition anywhere so that 0 values are ignored in average calculation?

Thanks for any idea,
USDarmy

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 2:25PM

    use your own variable to track recordcount
    in the obp of the data band write code to inc counter if value of field is >0
    in the footer use sum function and / by counter variable.
    ;)
  • edited 2:25PM
    Very simply,
    thanks, USDarmy

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.