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.
|
Event Logging - Record Deletion
Viewed 1755 times since Wed, Sep 21, 2016
Discount and Supplier Matrix Prevent Sale of Items to Selected Customers
Viewed 1893 times since Fri, May 20, 2016
Datafile Software - Hardware and Software Supported Versions
Viewed 12507 times since Thu, Dec 13, 2012
Default Text as Data Items
Viewed 3840 times since Wed, Jun 13, 2012
ASCII Import with Line Feed Only Record Delimiter
Viewed 4046 times since Wed, Jun 13, 2012
Email Attachments - Create PDF Files in Main Report Folder
Viewed 2003 times since Fri, Jun 8, 2012
Emails in HTML Format (Outlook 2007) 2
Viewed 142 times since Thu, Sep 4, 2014
Email Documents - Set CC and BCC Email Addresses
Viewed 1727 times since Wed, Sep 21, 2016
Sales Order / Works Order Enquiry Links
Viewed 3173 times since Mon, Nov 25, 2013
Include Attachments on Documents to Email
Viewed 1989 times since Tue, Jun 12, 2012
|