Stimulsoft Business Intelligence System | Forum

hello

I wanted to average 5 data column values, but there might be one or many data column that might be NULL, is there a way I can average them, ignoring the NULL.

Thanks

Neel Kamat

Hello, Neel.

The answer depends on the way you use our product and structure of the report.
You could set the filter of the DataBand to miss unnecessary rows.
Other solution is to use more complicated expression.

Could you send us your report template with sample data and we will prepare more detailed answer for you.

Thank you.

Hello HighAley,

How do I share the report template with you? Will .oap format work?

Thanks

Hello HighAley,

I apologize for the delayed response, I got caught up with other things and now have started working on this report again.

How do I share the report template with you? Will .oap format work?

Thanks

Hello,

We meant our internal format .mrt and test or actiual data to it. You can attach it to this forum thread.

Waiting for your reply.
Thank you.

Hello.

What is the .oap format? Do you use our tool that is embedded in an other application?

Thank you.

I am using a tool called Optimist which uses Stimulsoft reports

Hello,

We couldn't say something about .oap format.
Can you please send us a .mrt file with test data for analysis.

Thank you.