-
1. Re: Going from regular format to percent difference with a parameter (changing the format in the calculated field) - Is this possible ?
Sasha Hanna Jan 30, 2019 9:10 AM (in response to Roger Pouly)Hi Roger,
The formatting issue can be resolved by returning a fraction and multiplying by 100 as well as adding "%" as part of your calculation. However even if you add more decimal places to the percentage value, does this return the expected ones, could you make sure that you are computing across?
Cheers,
Sasha
-
2. Re: Going from regular format to percent difference with a parameter (changing the format in the calculated field) - Is this possible ?
Roger Pouly Jan 30, 2019 9:27 AM (in response to Sasha Hanna)Hi Sasha, thank you for this quick answer.
Would you mind explaining what do you mean by "returning a fraction and multiplying by 100 as well as adding "%" as part of your calculation" ? I don't quite get what to do.
This is computed accross indeed, and returns the expected results.
Thank you,
Roger
-
3. Re: Going from regular format to percent difference with a parameter (changing the format in the calculated field) - Is this possible ?
Sasha Hanna Feb 1, 2019 2:25 AM (in response to Roger Pouly)1 of 1 people found this helpfulHi Roger,
Apologies for not being clear, it is not possible to set different formats in a single measure (although it has several outputs dependant on your parameter). My thoughts were to return the percentage value, so for destination 1 = 42.18 and add the percentage symbol to it with a calculation like this:
str([%number of sales])+"%"
Hope this helps!
Cheers,
Sasha
-
4. Re: Going from regular format to percent difference with a parameter (changing the format in the calculated field) - Is this possible ?
Roger Pouly Feb 1, 2019 2:34 AM (in response to Sasha Hanna)Hi Sasha,
Thank you for your answer. I need to use measures so it is a bit sad, I guess I'll need to find another way to convey this information.
Have a nice day,
Roger
-
5. Re: Going from regular format to percent difference with a parameter (changing the format in the calculated field) - Is this possible ?
Sasha Hanna Feb 1, 2019 2:39 AM (in response to Roger Pouly)No problem, here is another very similar but possible workaround:
https://www.theinformationlab.co.uk/2015/01/29/passing-formats-parameters/
Cheers,
Sasha
-
6. Re: Going from regular format to percent difference with a parameter (changing the format in the calculated field) - Is this possible ?
Roger Pouly Feb 1, 2019 3:16 AM (in response to Sasha Hanna)Good find ! It is weird, because my first approach was to try something like this, but my measure still showed even when Null, meaning both measures would show anyway :
In the Information Lab article though, only the selected measure show on the workbook. Maybe because it is from 4 years ago ?
Thanks,
Roger