Use field as expression

[alan_grn]

I have a table that has two fields. one is Report no, the other has a formula in it. (called Formula)

For example Report 1, Sum(Value). Can I use the Formula field as an expression. I keep getting a no data to dipslay error message.

[pover · Accepted solution]

Create a variable that looks like this:

=Formula

Then in the expression of the report put $(Variable). This will expand the formula first and then calculate it.

Regards.

[alan_grn]

Thanks. It was the = in the formula that was missing.