Dynamic values does not give expected results

[wlaing]

When entering a value in the dynamic text box, it gives a result that does not align with my data. For example when I enter "Available to Obligate" the expected result should match the table to the left which reads $14,621,963,180. Instead, the dynamic value result is 403,435,110,844.24. I am unsure what calculations the dynamic text is doing to produce this result. 

[Anonymous · Accepted solution]

Hi @wlaing ,

Below is my table:

The dynamic value calculate the total of the column:

When you filter the dynamic text , you can achieve this result:

Where you find that the dynamic text values do not correspond to the values in the table, the reason is that the values in the dynamic text are calculated directly from the sum of all the values, whereas the values in your table will display certain values due to the influence of filters.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.