Creating new Calculations within a Sage 200 BI report

It may be that you would like a calculation not available as standard within a BI report and that you would like that calculation saved and available for other BI reports from the same cube.

 

The following illustrates the process of achieving this :

 

In this example right click on 2008 2009 and 2010 – new calculation.

As seen below this defaults to SUM but can be edited

 

This calculation is now available for inclusion on the report, to save for other reports from this cube click on Sets\Calcs and ‘save to library’ :