CALCFIELDS in NAV2015

Roelof

I have a weird issue. I'm trying to get a value from a calculated field, by using the 'CALCFIELDS' function.
When I run the table I can see the calculated value. But when I use the 'CALCFIELDS' function in a report or CodeUnit it is just not calculating. I ran the debugger and all that and no value. It's zero.
Any ideas what could be the cause?

rjbeltran

You can use CalcFields Property in reports.

rjbeltran

You have to set certain field to "Flowfield" so you can use calcfields. When you did not set that and you tried to get the value, for sure you will get a zero value.

Roelof

Yes, the fields in question are defined as flowfields. That's not the issue.
The table itself is not part of the report data-items so I can not use the 'calcfield' property'. The table is defined as a global variable.
This is a very strange behavior. I have used many times calcfields but I've never seen this.

Roelof

Never mind. I have figured it out. The table wasn't reset in the code properly.