Topic Options
#6507 - 10/10/03 09:53 AM All Symbols
Anonymous
Unregistered


Dear Community,

I am trying to create various Department reports. However, I am having a hard time with the symbols used in this software.

Can someone tell me what these symbols mean?
* $ & " ' ` , - )) .. /

I think that .. = Sum

Thank you,


Top
#6508 - 10/10/03 04:53 PM Re: All Symbols
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Hello Ana,

Adagio's Financial Reporter uses formulas that are similar in construction to Excel spreadsheet formulas. Is this where you are finding these symbols, or are you referring to the toolbar buttons?

Without understanding exactly the question you're asking - here are some answers that might help:

For the symbols:

* = multiply (2*3=6)
$ = Format cell as currency (on the toolbar)
& = concatenate 2 strings ("A"&"B"="AB")
" = a string (text) constant ("Hello")
' = Marks cell contents as a string
` = A placeholder for the department selected from the toolbar
, = Used to separate accounts that you wish to sum (1000,2000), or on the toolbar to format selected cells as numbers.
- = subtraction or the department separator (4-3=1 or "1000-200" means account 1000 department 200 depending on context
) = Closes an opening parenthesis ("(")
.. = specifies a range of cells (=SUM(A1..C3))
/ = divide operator (6/3=2)

To see an example of a departmental comparative statement, open GL!DeptDemo.sam (or AF!DeptDemo.sam if you are looking at Adagio FX) in the sample data. Also, check out the web seminars on the Financial Reporter and Adagio FX at http://www.softrak.com/webinars.html.

You will also find a helpful description of how the formulas work in the online help (Press F1).


Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 45 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1847 Members
5 Forums
14239 Topics
69728 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31