Changes
Jump to:
navigation
,
search
Custom Field Type: Special - Advanced Data Table
504 bytes added
,
14:18, 5 December 2022
m
→
Adding a formula to a cell (working with data in the same section)
{{Show Clear Button}}
{{Display fields refreshed upon edit}}
{{Custom Field Ids}}
So if you wanted to add the values of row 1 and 2 together in column 1 you would enter '''=[1,1]+[2,1]'''.
To minimize divide by zero errors, you can first check if the denominator is 0 (and set value to 0) by using the following syntax:
<pre>=(ssParseNum([1,3])==0 ? 0 : ([1,2]/[1,3])*100)</pre>
==Adding a formula to a cell (working with data in the different sections)==
e.g. '''=[@section.''expense''.id@_''Total_Amount'']-[@section.''income''.id@_''Existing-funds''_''Amount'']'''
If you need want to display data in the head of a section (row 0) from another section you can use the following:
'''@xml.customfieldname.sectionnodename.rownodename.columnnodename@'''
==Validate values when saving the worksheet==
<pre><!--@sscalculation(format("@xml.fieldname.sectionnodename.rownodename.columnodename.nodevalue@",2))--></pre>
* Extract a filtered row count from a '''dynamic''' XML section.
<pre><!--@sscalculation(@xml.XML Field.People.Person[#(?criteria="~type.nodevalue~" == "A") 1+#]@ 0)--></pre>
* Extract a percentage value and '''format with two decimal places'''. If pulled from a '''dynamic''' XML section then you will see multiple values.
* Return a single value in the total row of a Dynamic XML.
<pre>@xml.fieldname.sectionnodename
.rownodename
.total.columnnodename.nodevalue@</pre>
==Styling Advanced Data Table for web, print and conversion to PDF==
← Older edit
Lorena Ruiz
Smartstaff
281
edits
Navigation menu
Personal tools
Log in
Namespaces
Special page
Variants
Views
More
Search
Navigation
Home
Articles by Index
Articles by Category
New Articles
Updated Articles
Tools
Special pages
Printable version