HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Creating Custom Calculations206
Look at the following table:
Notice that the figures in the Min by Year column are the same as those in the block
footers in the example ”Specifying an output context” on page 204, even though this
block contains an additional dimension, Month. This is because the formula for Min by
Year explicitly excludes Month from the input context. The formula looks like this:
Min ([Sales Revenue] In ([Year];[Quarter])) In ([Year])
This formula tells Web Intelligence to ignore month and calculate revenues by year and
quarter (the input context), then output the smallest of these revenues for each year (the