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,
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).