Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.

Display: Comma separated numbers in custom fields and calculated fields

Avatar

Level 2
  1. Is it possible to display numeric values with comma separators in both input custom fields and the associated calculated fields for better readability?

  2. Currently, when users update the underlying custom fields multiple times after saving the input form, the calculated fields do not reflect these changes dynamically. Is there a way to auto-refresh the calculated fields to reflect the latest updates without requiring an additional save?

 
4 Replies

Avatar

Community Advisor

ApaliNa1 -

I'm not sure I'm understanding your items but for 1, you could try to use the Validation filter to see if the field contains a comma to help the user input the comma.  For 2, calculated fields should be auto-refresh so if you're not seeing that happen then open a support ticket.  Again, I can't see what you're looking at to better understand but hopefully this provides some direction.

Avatar

Level 2

Hello, 

Sharing the snippet: When I use Num1 and Num2 as currency field with a calculated field Sum (currency)with expression,its not calculating the digits placed after comma and the sum value too is incorrect: refer below screens

 

NUMBER(SUM({DE:Num1},{DE:Num2}))
 

ApaliNa1_0-1753419643310.png

Question is :How can I use other currency option besides USD in custom fields and how to accurately calculate sum of currency values?

2:what's the best way to define cross currency values in a custom from and introduce fx rates for conversion to base local currency.

 

Avatar

Level 2

The ask was simple by business, I want the money values to be separated by comma as we done in International Number system format, for better readability.

Avatar

Administrator

@ApaliNa1 Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!



Kautuk Sahni