Number format on personalisation variables

(1) Share

Report

Posted on by eyeballkid

Hi,

I am designing a survey in which we want to inject some data from Dynamics via variables. One of the variables are numbers which seem to be displaying strangely in the survey if any kind of formatting is applied to the spreadsheet. For example, if I have a number in the spreadsheet of 6,345,643 it displays as ''6 in the survey. If I strip out all formatting and use the general format in excel so the number is 6345643 it displays in the survey but is difficult to read as it is supposed to be currency i.e. £6,345,643.

Is there a way of getting the survey to display the correctly formatted number?

Thanks,

Jonathan

All responses (1)

Answers (0)

VaHiX 2,225 on at

Like (1)

Report

Number format on personalisation variables

When setting up the survey in Dynamics, ensure that the variable is correctly configured to display the number as currency. You might need to specify the formatting options for the variable.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-format-field-data