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.
|
Warehouse Tablet - Show Stock Image on Enquiry
Viewed 634 times since Wed, Oct 23, 2024
Output to Pivot Tables - Accept and Save Options
Viewed 5259 times since Tue, Jun 12, 2012
Application Utilities Panel - Allow Scans Enquiry
Viewed 2579 times since Fri, Jun 8, 2012
User-Definable Ledger Enquiry Applications
Viewed 21987 times since Tue, Jun 12, 2012
Landing Grids
Viewed 2221 times since Mon, Jun 26, 2017
Sales/Purchase - Links to Order Enquiry from Transactions
Viewed 3312 times since Tue, Jun 12, 2012
Emails in HTML Format (Outlook 2007)
Viewed 5048 times since Mon, Jun 11, 2012
General System Options - Copy a User Id
Viewed 271 times since Thu, Oct 17, 2024
Increase History List to Ten Items
Viewed 2543 times since Tue, Jun 12, 2012
Data Visualisations
Viewed 1961 times since Thu, Jun 18, 2020
|