Skip to main content
Nintex Community Menu Bar
Question

Merge syntax on ui-only formula fields not displaying data according to metadata

  • July 9, 2024
  • 9 replies
  • 10 views

Forum|alt.badge.img+18

Ui-only field like this:

Merge Syntax like this:

{{$Model.scheduledInitialAppointments.data.0.Percent}}

Expected Result in runtime:
47%

Actual Result in runtime:

0.4727272727272727

9 replies

Forum|alt.badge.img+18
  • Author
  • July 10, 2024

Anyone know a way around this? the long strings of numbers are getting really ugly…


Forum|alt.badge.img+18
  • Author
  • July 10, 2024

I suppose I could ROUND(value*100) to all my percent fields, and return them as TEXT instead with + ‘%’


Forum|alt.badge.img+17
  • Nintex Employee
  • July 10, 2024

Are you sure that your “percent” field is not a string field?  If it is you just need to mulply it by 1 and then the percentage rendering tools in the formula will work. 


Forum|alt.badge.img+18
  • Author
  • July 10, 2024

Rob,

Take a look at the image in the original post. The “Percent” field is a formula field with type Percent.
Length 3, Decimals 0.


Forum|alt.badge.img+17
  • Nintex Employee
  • July 10, 2024

Ok,  I misunderstood.  I thought that your formula was:   {{$Model.scheduledInitialAppointments.data.0.Percent}}    (Which is a valid formula btw)  I guess you are using the merge syntax to show the field on your page, and in that case you are right - we are not processing the rendering suggested by the metadata override.  This has been noted…


Forum|alt.badge.img+18
  • Author
  • July 10, 2024

Thanks, Rob…

Any thoughts on when this might be updated? I have to weigh the work of changing all my percent formula fields to text fields with ROUND(old_percent_formula) + ‘%’… or waiting until the fix…



Forum|alt.badge.img+18
  • Author
  • July 10, 2024

As an aside… being able to use global merge syntax in formulas is awesome. 🙂


Forum|alt.badge.img+18
  • Author
  • July 10, 2024

any update on this?


Forum|alt.badge.img+10
  • July 10, 2024

I am experiencing this issue as well. Trying to use a Ui-Only percent field in the title of a graph and the meta data is not being honored. Any update on this?