Home » Categories » Solutions by Business Process » System Features |
Datafile Software - Special Table Calculation Items |
Article Number: 1901 | Rating: 5/5 from 1 votes | Last Updated: Tue, Jun 20, 2023 at 6:01 PM
|
System Utilities Special !C Database !C1 If less !C2 If greater !C3 If negative !C4 If positive !C5 Highest of !C6 Lowest of !C7 Force !C8 Count of !C9 Value in range +Dnnn - +Dnnn relative !C10 Negative result when multiply value by !C11 Vat Rate – follow by !Cnn where nn is tax !C12 Lowest of items included in +Dnnn - +Dnnn !C13 Accumulated value in range +Dnnn - +Dnnn !C14 Force calculate to 2dp !C15 Return record number as value !C16 Index Search ‘Group' – if create item !C29 Date/Time Difference - +DFromDateItem !C30 Round down to whole numbers – i.e. 12.56 !C36 Number of non-blank characters in (upto) !C37 As !C36 but can test whether specific !C38 Total Range of Values. If have items Qty, Width, Height, Depth and !C39 Round up/down to whole numbers if ‘Y' in !C40 Square Root of Value !C41 Round to whole numbers – i.e. 12.34 |
Attachments
There are no attachments for this article.
|
Ledger Enquiry Hyperlinks on Application Report Output to Excel
Viewed 10719 times since Mon, Jun 11, 2012
Document Design Manager - Page Set-up
Viewed 4403 times since Wed, Jun 13, 2012
Document Design Manager - Inserting New Items
Viewed 2251 times since Wed, Jun 13, 2012
Help Bubble Display Size
Viewed 1658 times since Fri, Jun 8, 2012
Extra 160 Items per Database
Viewed 1649 times since Wed, Jun 13, 2012
Datafile Software - Menu Application Files
Viewed 2112 times since Wed, Jun 13, 2012
Ledger Enquiry Links to Discount and Supplier Matrix
Viewed 1490 times since Fri, May 20, 2016
User Help Notes
Viewed 1835 times since Fri, Jun 8, 2012
4K Record Size Limit
Viewed 1751 times since Wed, Jun 13, 2012
Save Email Attachments Separately
Viewed 1798 times since Fri, Jun 8, 2012
|