Change column from Basic Table Tool from decimal to percentage

Hello,

Im using the Basic table tool, and I have encountered one issue, i want to replace values from one column which are in decimals to percetages after the rules have been applied (Background color rules), but I cannot replace the number to percetages,

See image below, the column Lates % is the one that i want to change to percentage as final rule

Please your help

THank you

image.png

Datasets

Input

Reporting

Output

Tips and Tricks

Custom Tools

Connectors

Transformation

Bug

Interface Tools

App Builder

Accepted answers

oyes2704

Alejandro,

Thanks for details - sounds like a very typical case for the Formula/ReportText combination.

Unfortunately your only options are dealing with sophisticated XML or preparing your data before the report. I modified the example to highlight the % in red/orange/green using the Report Text option.

1. Formula will create 3 variables with values only for the required range.

Text will "Concatenate" all three variables in different colors.

The report will use the new "Text" element to show the value in the correct layout:

Hope that helps to resolve your issue. Please see this workflow attached.

Best,

Oly

inventory3.yxmd

All comments

Qiu

@alejandrogarayacosta
Decimal is still a numeric value, and if you want to change it to %, it will be come a String.
maybe that is the reason?
Can you show us what did you tempt to change with a snapshot?

alejandrogarayacosta

This is the flow, after the basic table highlighted, i want to convert the column Late % to percetage but as you can see i cannot select the column, the table is the only thing appearing in the select tool for example

image.png

oyes2704

Hi Alejandra,

the Table creates XML objects for the Grouping variables. It would be difficult to adjust the content from there. You can convert the layout of the column before you use the Table Tool. Please see simple workflow I included:

1. Formula tool that formats Inventory availability to text with %.

2. Basic Table Grouping by Inventory categories like desks in my case

3. Select after Table shows each Inventory group and the "Table" XM L column

Please see the workflow attached.

Best of luck,

Oly

inventory.yxmd

alejandrogarayacosta

Hello All, thank you for your answers

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703