percentDifference (formattedValue and formattedAbsoluteValue) in custom narrative not formatted by the metric field

[Saurabh]

I have having PeriodToDate computation with value as datemeasurefield having AggregationFunction as count. I have defined the decimal separator as COMMA and ThousandsSeparator as DOT (due to finnish region) but when i used percentDifference.formattedAbsoluteValue it is always showing me result with DOT as decimal separator. As per documentation formattedAbsoluteValue follows metric formatting. If i use currentMetricValue.formattedValue then result is as expected.

Also i am having one more “PeriodToDate” computation with value as NumericalMeasureField having SimpleNumericalAggregation as SUM. In this case also percentDifference.formattedAbsoluteValue is always using DOT. currentMetricValue.formattedValue

[Thomas]

Hi @Saurabh,
I’m having difficulties reproducing what you’ve described. Could you please create a small example showcasing the challenge you are facing within the QuickSight Arena and share it here with the community?

Thanks in advance!

[abacon]

Hi @Saurabh,
I’m just checking if you need help on this question, as we have not heard back from you. If the previous response did help, please mark his reply as solution. If we do not hear back in the next 7 days, we will archive the question.
Many Thanks,
Andrew

[Saurabh]

Adding some snapshots if that help in reproducing. I have Insights visual as below -

I have added a computation as below -

Then I added below in my narrative

as

In this case data is shown as

It always shows decimal separator as DOT.
Although the formatting of value was set as

[Thomas]

Thanks @Saurabh for sharing the screenshots. That helped to reproduce your challenge.
As you are at the moment only able to define the formatting for the date1 (Count) metric, but not the percentDifference calculated with the computation of the Insight visual, you could alternatively do the computation in a calculated field, using the periodOverPeriodPercentDifference function, and then have full control over the format of the percentage formattedValue in the narrative.

The calculated function would look similar to this: periodOverPeriodPercentDifference(count({Order Date}),{Order Date},YEAR,1)

And then you would add the new calculated field to the Values of the Insight visual, wherein you can define your formatting preferences. In the screenshot below, you can see how this approach allows to freely adjust the formatting of the field’s formattedValue.

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!