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.
|
History Database Cross-Links
Viewed 1985 times since Tue, Jun 12, 2012
F4-Search - Default Item
Viewed 1807 times since Fri, Jun 8, 2012
F4-Select - Exact Code Match Entry
Viewed 2010 times since Tue, Jun 12, 2012
Desktop Database Tools - Additional F4-Select Options
Viewed 1990 times since Fri, Jun 8, 2012
Password Security
Viewed 685 times since Thu, Jun 18, 2020
Sales / Purchase – Transactions to be Displayed
Viewed 1058 times since Tue, Jun 12, 2012
Document Design Image Display Properties
Viewed 2071 times since Fri, Jun 8, 2012
Call Individual Report Generator Option
Viewed 1845 times since Tue, Jun 12, 2012
Document Design Manager - Converting A Document
Viewed 2269 times since Wed, Jun 13, 2012
Ledger Enquiry – New Label Print Option
Viewed 1236 times since Wed, Jun 13, 2012
|