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.
|
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4846 times since Fri, Jul 21, 2017
Microsoft Office Links 2018
Viewed 1458 times since Thu, Jun 18, 2020
Ledger Enquiry CRM Authority Levels
Viewed 2031 times since Mon, Nov 25, 2013
Password Security
Viewed 1046 times since Thu, Jun 18, 2020
Additional Price Checker Options
Viewed 2038 times since Mon, Jun 11, 2012
Landing Pages - Check for Refresh Every X Minutes
Viewed 185 times since Tue, Oct 15, 2024
Ledger Enquiry / Display Notes by Department
Viewed 2218 times since Mon, Jun 11, 2012
Bar Code Printing
Viewed 1106 times since Mon, Jan 6, 2020
Ledger Enquiry - Increased No of Stock Location Pick Items
Viewed 193 times since Thu, Oct 17, 2024
General System Options - Email Address Format Validation
Viewed 244 times since Thu, Oct 17, 2024
|