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.
|
Validate Account and Stock Groups Entries
Viewed 1989 times since Fri, May 27, 2016
Output to Pivot Tables - Accept and Save Options
Viewed 4698 times since Tue, Jun 12, 2012
Copy to Clipboard - Use <TAB> Delimiter
Viewed 3812 times since Fri, Oct 26, 2012
Landing Pages - Edit Data Items from Landing Page
Viewed 190 times since Tue, Oct 15, 2024
ASCII Import with Line Feed Only Record Delimiter
Viewed 4332 times since Wed, Jun 13, 2012
Ledger Enquiry - Copy Enquiry Screen Setup
Viewed 192 times since Thu, Oct 17, 2024
Datafile Software - Menu Parameter Listing
Viewed 3002 times since Wed, Jun 13, 2012
Print Database Structure
Viewed 2190 times since Mon, Jun 11, 2012
Nominal Enquiry - Links to Sales/Purchase Transactions
Viewed 9745 times since Tue, Jun 12, 2012
Alternate Panels in Ledger Enquiry
Viewed 2077 times since Tue, Jun 12, 2012
|