info("expandable") function

info("expandable")

The info(“expandable”) function checks to see if the current record is expandable.

Description

This function checks to see if the current record is expandable, in other words, is it a summary record with one or more collapsed child records? This function returns the count of any collapsed child records, if there are none, it returns zero.

This example could be used as a formula for a Image Display Object. This object will display an arrow that shows whether this record is expandable or not, much like the outline view in the Finder.

?(info("expandable"),"right arrow","up arrow")

See Also

analyzedialog -- opens the standard Analyze dialog.
average -- calculates averages and sub-averages for the selected records in the current field.
collapse -- hides the detail records associated with the currently active summary record.
collapsetosummary -- collapses to the next higher summary level.
count -- counts all non-empty data cells for the current field.
expand -- reveals the next level of collapsed detail records associated with the currently active summary record.
expandall -- reveals all collapsed detail records associated with the currently active summary record.
groupdown -- divides the database into groups, with a summary record at the end of each group. The groups are arranged in descending order (high to low).
groupup -- divides the database into groups, with a summary record at the end of each group. The groups are arranged in ascending order (low to high).
info("collapsible") -- checks to see if the current record is collapsible.
maximum -- calculates the maximum and sub-maximums for the current field.
minimum -- calculates the minimum and sub-minimums for the current field.
removeallsummaries -- removes all summary records.
removedetail -- removes data records from the current database, leaving only summary records. It can also delete low level summary records, leaving only higher levels.
removesummaries -- removes summary records from the current database.
total -- calculates totals and subtotals for the current field.

History

Version	Status	Notes
10.0	Updated	Carried over from Panorama 6.0, but returns the actual count of collapsed child records (in Panorama 6.0 and earlier, this function would return 0 or 1, no matter how many collapsed child records were there.)