I’m looking for a way to round the percent values in the top/bottom movers’ insights narrative.
The value is presented with two decimal positions (56.98%). I want to round it to an integer (57%). I tried using the ‘round’ calculation and got the following error:
Hello @Yuval.Shiboli, could you try changing the format of the value from the field well? Click the down arrow on the field you want to target, hover over format, and select more formatting options (or you can select the option that just shows a percent value without decimal places). This should allow QuickSight to handle the rounding functionality on the insight display.
Hello @Yuval.Shiboli, I see on your original ifelse statment you put the round functionality outside of the whole ifelse statement. Could you try using it on the element that returns a percent value in the narrative instead?
Hello @Yuval.Shiboli, oh I think it is because you are using the formattedAbsoluteValue. Using that or formatted value is converting the returned value to a string so it is not able to run the rounding function. Maybe try percentDifference.value instead then the rounding should work.
Amazing- using the “value” computation along with the round() function and adding the % as text right after it- got me to where I wanted to be.
Thanks for all your support @DylanM - I will save that article on my favs for future narratives.