Collapse all | Expand all
Change A Date
Example uses the MATH and DATE functions to add 10 days to a date
selected in the spool file.
downloadReformat A Dollar Amount
Example uses the MATH function to reformat a dollar amount. The MATH function multiplies the selected amount from the spool file by one and reformats it with a dollar sign in front, a comma separating thousands from ten thousands and so on, and two decimal places.
downloadReformat Columns of Numbers
Example uses the MATH function to reformat columns of numbers. Each column is loaded to a buffer separately. The ED function eliminates leading zeros. Each column is read from the buffer and mulitplied by one so the MATH function can format it with commas, a leading dollar sign and two decimal places. The reformatted column is read back into the same buffer replacing the unformatted numbers.
downloadAdd a Column of Numbers
Example adds a column of numbers in the spool file and subtotals it.
downloadCreate New Date
Example creates new date based on date in the spool file using the MATH DATE function.
download
