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.
|
Pre-Defined Criteria - $USER for Current User Id
Viewed 1306 times since Thu, Jun 18, 2020
Microsoft Office Links 2018
Viewed 2126 times since Thu, Jun 18, 2020
Document Design Manager - Setting and Applying Font Defaults
Viewed 2861 times since Wed, Jun 13, 2012
Alternate Image Viewer
Viewed 2338 times since Mon, Nov 25, 2013
Table Maintenance
Viewed 2272 times since Mon, Nov 25, 2013
Selection Criteria Range ‘Value’ Input
Viewed 2646 times since Fri, May 27, 2016
General System Options - Copy a User Id
Viewed 262 times since Thu, Oct 17, 2024
Ledger Enquiry Hyperlinks on Application Report Output to Excel
Viewed 11107 times since Mon, Jun 11, 2012
Default Transaction Filters
Viewed 2134 times since Tue, Jun 12, 2012
Ledger Enquiry - Prevent Auto Close of Associated File Folder on Enquiry
Viewed 641 times since Wed, Oct 23, 2024
|