Skip to content

Business Intelligence Tools

  • BusinessObjects

Sum of Positive/Negative Values in Web Intelligence

Posted bydmytro September 18, 2014September 18, 2014

=Sum((If [Value]>0 Then [Value]) ForEach([Service]))

=Sum((If [Value]<0 Then [Value]) ForEach([Service]))

Posted bydmytroSeptember 18, 2014September 18, 2014Posted inWeb Intelligence

Post navigation

Previous Post Previous post:
Weird merging issue in BO XI 3.1 SP5
Next Post Next post:
Misc. Dates – SQL Server
View Dmytro Bukhantsov's profile on LinkedIn

Unx Universe Documenter

Biclever Unx Documenter is a tool for extracting Unx metadata to Excel. Free. Does not require installation.

Unv Universe Documenter

Create documentation of your Unv universes in Excel format with free tool Biclever Unv Documenter

CMS Query Builder

Biclever CMS Query Builder - free tool for querying CMS database and exporting the result to Excel

About

This is a blog about business intelligence, data warehousing, databases, programming etc. The opinions expressed here represent my own and may or may not reflect the opinions or policies of my employer. The site is not endorsed by or affiliated with SAP, SAS, Oracle, Microsoft etc. The information, source code, and software available on this web site is provided "as is" without warranty of any kind blah-blah-blah...

Business Intelligence Tools, Proudly powered by WordPress.