Skip to main content
Microsoft Dynamics NAV forum
Answered

Why variables are used on statistics pages and not fields?

editSubscribe (1) ShareShare
ReportReport
Posted on by 60

Hello everyone,

I have this question confusing me since forever, When do I use fields and when to use variables to have dynamics values calculated when opening a page?
what's wrong with the use of fields from a table instead of variables ?

Thanks in advance

  • Verified answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Why variables are used on statistics pages and not fields?

    Could you please give an example of what you mean for "dynamics values"?

    If you mean flowfields, these are automatically calculated when the field is bounded to the page and it opens.

    You could also do some exercises related to Autocalcfields property and SETAUTOCALCFIELDS function

    docs.microsoft.com/.../setautocalcfields-function--record-

    to better understand when and how these are calculated.

    Be aware of the performance payload in always calculating fields, when you have a lot of records in the underlying tables.

    Basically, flowfields are declared within a table and are part of the table / tableextension that you are using.

    Variables, calculates values on the fly and might fit best when

    a. these are used spot (e.g. just in one page or one report)

    b. values comes from etherogenous sources (e.g. multiple different tables)

    Up to you, as developer, to find out the best solution that fits your specific needs.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans