General information
Category:
Reports & Report designer
Thank you very nuch, I'll try it right now
Best regards
Thomas
>Hi there,
>
>I am trying to figure out how to create a report var calculation an average value but avoiding records where the value of the field is o. How can I do this?
>
>Thanks in advance
>
>Thomas
SUM(FIeld) / SUM(IIF(Field = 0, 0, 1))
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only