Forum Discussion
Displaying Ratio on Multi-Row Card
The goal is to display a ratio on a multi-row card. I am aware that the multi-row card can only display numbers but looking for advice on how to make this work. I tried to convert both the entire ratio + portions of the ratio into number using VALUE but it is not formatting the correct way. Any advice on how to display a ratio on Multi-Row Card as a number will be greatly appreciated.
Current Syntax (notice screenshot below as the ratio is reflected in BLUE >>> the goal is to reflect the ratio as a number in black like the other numbers)
VALUE( [Overdue Lifecycle Count] ) & " / " & VALUE( [Pattern Count] )
You can display text in multi-row cards. Are you getting an error that makes you think otherwise? If so, the root cause is not the visual's capabilities.
Example:
Number = 87462 Percent = .12365 Ratio1 = 10 & " / " & 3 Ratio2 = 30 & " / " & 1 Ratio3 = 2 & " / " & 5 Text = "Hello World!"MarkLaf thanks for the advice. I ultimately had to get rid of all the fields and drop them back in to get the formatting corrected. This put the ratio into the correct format.
3 Replies
- MarkLaf
Super User
You can display text in multi-row cards. Are you getting an error that makes you think otherwise? If so, the root cause is not the visual's capabilities.
Example:
Number = 87462 Percent = .12365 Ratio1 = 10 & " / " & 3 Ratio2 = 30 & " / " & 1 Ratio3 = 2 & " / " & 5 Text = "Hello World!" - VijayP
Community Champion
Anonymous
Format(Divide(Numerator,Denominator),"%") and see whether it works!
MarkLaf thanks for the advice. I ultimately had to get rid of all the fields and drop them back in to get the formatting corrected. This put the ratio into the correct format.
