Versions Compared

Old Version 1

changes.mady.by.user Helen Gosper

Saved on

compared with

New Version Current

changes.mady.by.user Denise McGettigan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Info
iconfalse
titleRelated topics
 
In period

In Period mode, the

first measure column after the Properties shows the total of the selected periods

first column after the Properties column(s) shows the total value for the selected period. This makes sense for streams that have cumulative data, such as

'sales invoices',

Sales Invoices but in streams that hold a snapshot of data showing the variance over time, such as

'stock

Stock on

hand'

Hand, the total is meaningless. For

example, if I have ten of an item on Monday, Tuesday and Wednesday, sell two, and then only have eight on Thursday and Friday, by the end of the week, I don't have '46', I still only have eight.On this type of stream

these types of streams, you can display the period total as an average, rather than a sum of the periods

, via Options > Totals as average. So, in the situation described in the above paragraph, the first measure column would show the average as '9.2'. This does not change the first 'totals' row of the view, just the totals column.The screen shots below show the effect of using Totals as average view. In the first image, the 'Total'

. 

For example, in the image below, the Total Value column displays the cumulative value of three month's worth of sales.

In the second image, the totals column

This is the typical (default) view.

Image Added

When you click Options > Totals as Average, that total column now displays the average of those sales, which is reflected in the new column header.

Typical view

Image Removed

Totals as average view

Image Removed

Note that the values in the TOTAL row of the period columns are not changed, just the values in the total column.

Image Added
Panel
bgColor#E3FCEF

Video

Show total as average

Related pages