CROMM versions

Previous item	Next item	Previous menu

(Updated 04.03.2008)

There has been three CROMM versions, made for IDEA 2002. Two of those versions are, however, available for IDEA 7, too. The versions are introduced below.

IDEA 2002
CROMM_02A
Demo version: CR02G

IDEA 7
Cr7a
Demo version: Demo version: cr7a2

The macro creates a table, where values of one numeric field are cross-tabulated in terms of values of two character fields. You can choose whether the column headings begin with prefix 'X_' or not. 'X_' beginning lets you always append table with virtual fields using the fields of pivot table, e.g. to determine VAT per cent of sales, gross profit per cent, operating profit per cent etc. In IDEA 7 versions all row headings of the resulting pivot table begin with '_'.

IDEA 2002
CROMM_02B
Demo version: None

IDEA 7
Cr7b
Demo version: cr7b2

The macro creates a table, where values of two numeric field are cross-tabulated in terms of (truncated) values of two character fields. You can choose whether the column headings begin with prefix 'X_' or not. Use this macro when you need a pivot-table where e.g. balances of both debit and credit entries or balances of both monetary values and physical amounts are cross-tabulated in terms of (truncated) values of two character fields. Very good in Entry Analysis. In IDEA 7 versions all row headings of the resulting pivot table begin with '_'.

IDEA 2002
CROMM_02C
Demo version: None

IDEA 7
[Cr7c][1]
Demo version: None

The macro creates a table, where values of three numeric field are cross-tabulated in terms of (truncated) values of two character fields. You can choose whether the column headings begin with prefix 'X_' or not. Use this macro when you need a pivot-table where e.g. balances of net entries from three years cross-tabulated in terms of (truncated) values of two character fields [2].

[1] No IDEA 7 version exists (in February 2008).
[2] How to make it? Make an IDEA database containing records from three years - e.g. appending files with same structure from 2001, 2002 and 2003. Let's assume that the file contains a numeric field "NET" and character field "YEAR" (indicating transaction year). Using these fields make three virtual numeric fields: NET_01, NET_02 and NET_03 using equations @if(YEAR="2001"; NET; 0), @if(YEAR="2002"; NET; 0), @if(YEAR="2003"; NET; 0) respectively. Use these virtual fields in making a pivot table.