Averge multiple data columns where some of them can be NULL
-
- Posts: 6
- Joined: Fri Jun 03, 2016 1:28 pm
Averge multiple data columns where some of them can be NULL
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
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
Re: Averge multiple data columns where some of them can be N
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.
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.
-
- Posts: 6
- Joined: Fri Jun 03, 2016 1:28 pm
Re: Averge multiple data columns where some of them can be N
Hello HighAley,
How do I share the report template with you? Will .oap format work?
Thanks
How do I share the report template with you? Will .oap format work?
Thanks
-
- Posts: 6
- Joined: Fri Jun 03, 2016 1:28 pm
Re: Averge multiple data columns where some of them can be N
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
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
Re: Averge multiple data columns where some of them can be N
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.
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.
Re: Averge multiple data columns where some of them can be N
Hello.
What is the .oap format? Do you use our tool that is embedded in an other application?
Thank you.
What is the .oap format? Do you use our tool that is embedded in an other application?
Thank you.
-
- Posts: 6
- Joined: Fri Jun 03, 2016 1:28 pm
Re: Averge multiple data columns where some of them can be N
I am using a tool called Optimist which uses Stimulsoft reports
Re: Averge multiple data columns where some of them can be N
Hello,
We couldn't say something about .oap format.
Can you please send us a .mrt file with test data for analysis.
Thank you.
We couldn't say something about .oap format.
Can you please send us a .mrt file with test data for analysis.
Thank you.