Introduction

This post will explain the expression used to reference a column in the current row of the query results.

For the previous row, please read this post.

Practices

A simple query is built using the SAP Business One datamodel.

It returns this dataset.

Now, I add an expression.

Use the reference tag: {%DocTot} for Document Total column in the current row. You can find it from here.

Then add 1,000 to it to make the formula Document Total + 1,000.

Click OK to save it.

Now for the preview! The expression returns the value with 1000 added to the Document Total.

Afterword

This is just an example and not practical, but I hope it helps you understand the use of the cell reference tag.

Back to Expressions.