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?
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.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.