Home » Categories » Solutions by Business Process » System Features

Datafile Software - Special Table Calculation Items

System Utilities

Special !C Database
Calculation Items

!C1 If less
than zero, make zero

!C2 If greater
than zero, make zero

!C3 If negative
make positive

!C4 If positive
make negative

!C5 Highest of
items included in +Dnnn - +Dnnn

!C6 Lowest of
items included in +Dnnn - +Dnnn (excludes zero)

!C7 Force
calculation to 4dp

!C8 Count of
non-zero values in range +Dnnn - +Dnnn

!C9 Value in range +Dnnn - +Dnnn relative
to known application period number.
Optionally followed by !Cn for offset and !Cn for values to accumulate.

!C10 Negative result when multiply value by
?-item and value is Y

!C11 Vat Rate – follow by !Cnn where nn is tax
code item

!C12 Lowest of items included in +Dnnn - +Dnnn
(includes zero)

!C13 Accumulated value in range +Dnnn - +Dnnn
relative to known application period number

!C14 Force calculate to 2dp

!C15 Return record number as value

!C16 Index Search ‘Group' – if create item
!C16 +D2 +D4 and reference as extra selection item in F4 then will allow entry
of text and display any matching records in items within the set range.

!C29 Date/Time Difference - +DFromDateItem
+DFromTime +DToDate +DToTime !C29.
Relies on C29DATES.TXT for time settings, weekend controls and bank
holiday settings.

!C30 Round down to whole numbers – i.e. 12.56
becomes 12.00

!C36 Number of non-blank characters in (upto)
two items – i.e. !C36 !C2 !C3 will calculate the number of characters in those
two items

!C37 As !C36 but can test whether specific
character position set – i.e. !C37 !C2
and then use selection criteria of item equal ‘5' will return any record where
the fifth character of field 2 is not blank.
Note can define two items so character test positions are consecutive.

!C38 Total Range of Values. If have items Qty, Width, Height, Depth and
have ten (say) sets of these items (consecutive) and want to add up total
values. Set calculation as !C38 !Cs !Ci
+DSTART –
where S is the number of sets and I is the number of items in a
set (each item in a set is multiplied together) and then the number of sets are
added together.

!C39 Round up/down to whole numbers if ‘Y' in
calculation

!C40 Square Root of Value

!C41 Round to whole numbers – i.e. 12.34
becomes 12.00, 12.56 becomes 13.00

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Ledger Enquiry – Update Sales / Purchase Accounts
Viewed 1748 times since Wed, Jun 13, 2012
Pre-Defined Criteria - $USER for Current User Id
Viewed 1184 times since Thu, Jun 18, 2020
Landing Pages - Copy Configuration between Users
Viewed 1013 times since Thu, Jun 18, 2020
Document Design Manager - The Document Design Toolbar
Viewed 2455 times since Wed, Jun 13, 2012
Document Design Manager - Moving, Deleting and Amending Items
Viewed 2393 times since Wed, Jun 13, 2012
Landing Pages - Multi-Search Option
Viewed 207 times since Tue, Oct 15, 2024
Ledger Enquiry – New Label Print Option
Viewed 1344 times since Wed, Jun 13, 2012
F4-Search - Default Item
Viewed 2086 times since Fri, Jun 8, 2012
Alternate Image Viewer
Viewed 1816 times since Mon, Nov 25, 2013
Additional Options for History / Analysis Enquiries
Viewed 1923 times since Fri, Oct 26, 2012