Averge multiple data columns where some of them can be NULL

Stimulsoft Reports.Silverlight discussion
Locked
neelnkamat
Posts: 6
Joined: Fri Jun 03, 2016 1:28 pm

Averge multiple data columns where some of them can be NULL

Post by neelnkamat »

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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Averge multiple data columns where some of them can be N

Post by HighAley »

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.
neelnkamat
Posts: 6
Joined: Fri Jun 03, 2016 1:28 pm

Re: Averge multiple data columns where some of them can be N

Post by neelnkamat »

Hello HighAley,

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

Thanks
neelnkamat
Posts: 6
Joined: Fri Jun 03, 2016 1:28 pm

Re: Averge multiple data columns where some of them can be N

Post by neelnkamat »

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
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Re: Averge multiple data columns where some of them can be N

Post by Andrew »

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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Averge multiple data columns where some of them can be N

Post by HighAley »

Hello.

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

Thank you.
neelnkamat
Posts: 6
Joined: Fri Jun 03, 2016 1:28 pm

Re: Averge multiple data columns where some of them can be N

Post by neelnkamat »

I am using a tool called Optimist which uses Stimulsoft reports
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Averge multiple data columns where some of them can be N

Post by Alex K. »

Hello,

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

Thank you.
Locked