I understand what a Repeating Dynamic Formula is and how it’s used, however, I am not too sure I understand plain Dynamic Formulas.
Could you please give an example on how to use it? Also, is there a way to return the number of rows in a datasource (something like Orders.Count) and use it in a formula?
Thanks
Hi,
Well, “&==DynamicFormula” works almost the same way as simple formulas e.g “=SUM(…)”. For your information, “&=&=RepeatDynamicFormula” will repeat formulas according the row numbers based on values of the data table. The “&==DynamicFormula” will not repeat itself but it will replace row or column in {r}or {c} accordingly and only once (one time). e.g. “&==B{r}” --> the formula might be =B1, where r refers to the current row where the smart marker is inserted. For your further information, we introduced this “DynamicFormula” marker initially (when we designed smart markers) when we did not have much variety of the smart markers, so there is not much use of it now a days except for a few cases. You may say that the “DynamicFormula” works almost the same way as simple formulas of MS Excel (it will be process one time).
For better understanding, you may replace dynamic formula with your existing repeat dynamic formula in your smart markers designer template file, process the markers and see the difference in the output file.
Regarding your second query, I think you may try to use COUNT () function in your SQL statement to return the number of orders e.g:
"SELECT COUNT() AS NumberOfOrders FROM Orders"
You may use simple markers or smart markers variables in the template file e.g “&=$VariableName” to get the count value in a cell and use it in the formula marker cell accordingly.
Thank you.