Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I show a text field as as two digit percentage? Example =sum ([fieldx]) / sum ([fieldy])*100

How do I show a text field as as two digit percentage? Example =sum ([fieldx]) / sum ([fieldy])*100 returns a long string nn.nnnnnnnnnn

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

=num(sum ([fieldx]) / sum ([fieldy])*100, '#.00 %')


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

=num(sum ([fieldx]) / sum ([fieldy])*100, '#.00 %')


talk is cheap, supply exceeds demand
Not applicable
Author

Thx you are so helpful!

Not applicable
Author

Thx you are so helpful!