Method Community

Thank you for the quick reponse and link. I might be terribly confused, but I think that the article did not change my question. My case is that I have values 1, 0, 0, 0 and want my average to be 1 (we calculate the score from customer feedback and those we cannot reach produce 0 - we still want to have it on the report, but we do not want it ...

I calculate an average of a value for a group, but it still takes the 0 into acount. Has anyone else encountered this problem? Thanks!

EDIT: figured it out - If Not(String.IsNullOrEmpty(item)) Hello! I am still improving this report with customized summaries and after I followed Matt's instructions, it works great. Until the input is empty - the picked dates generate no data and the report should be empty.Then I get an error message, because I ...

Thanks!

I actually need to do the exact same thing at the moment! 

EDIT: the problem was in our data - sometimes we accidentaly added an empty value. I have recently created a report using scripting (might be relevant) that calculates sum of groups based on specific criteria. While it works when I generate a report for a time window shorter than (about) 2 and half months, when the time frame is ...

Thank you both! I think that I know what to do now and I will see if it works! Thanks again.

Hello! I am trying to create a summary for a group, but calculate it only for items that fit into specific category. I cannot figure out a way how to make a conditional summary, does anyone have experience with that? I would really appreciate your help! Thanks!