nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Conditional Formatting of Dynamic Columns

azkh

I have a set of data that consist of multiple different types of Material quantity for each different material, I conditionally formatted it to color code it red when a material qty is negative(-ve) and color code it green when material qty is positive(+ve).

I am facing issue in eliminating zero values

here null cells in my data are also displaying in Table tool I want it to be blank (without green or red color)

I am generating a forecast report in which month columns will change dynamically if there is another way to do this pls suggest.....

I have attached sample workflow
Any Help would be appreciated...

color formatting-AZ.yxmd

Reporting

Dynamic Processing

Accepted answers

danilang

Hi @azkh

To make this solution dynamic, add a multirow tool before @grossal's filter tool and set it to generate an incremental [ColumnNumber] field. Change the Crosstab tool so that it uses Column Number as the Column Header and change the Dynamic Rename so that it uses [ColumnNumber] as Old Field Name. This way your columns will always be in the order listed in your input and you won't have to manually rearrange them in your table tool.

Dan

color formatting-AZ w Dynamic Columns.yxmd

All comments

grossal

Hi @azkh,

sticking to the way already used, you could do the following, by simply adding an additional filter in front, as well as one more Report Text tool.

The Filter passes all 'Value's that are either empty/null or 0 to the false anchor and than in a normal Text Report tool. The result looks like this:

For a moment I thought about transposing it first and than configuring it purely in the Basic Table tool, but this would probably create more work than the way you used. The alternative Batch Macro solution would probably also create more work.

Best

Alex

danilang

Hi @azkh

Dan

color formatting-AZ w Dynamic Columns.yxmd

grossal

Great improvement @danilang! love it.

azkh

@grossal @danilang Thanks for the Help!
The solution you gave works for me, there were still some zeros in the output Table so I made some changes and now it is all well.

Thanks Again!

grossal

That's great to hear @azkh!

Would be lovely if you could post a screenshot / workflow of it. Maybe others will stumble across the exact same problem in the future and would appreciate it :-)

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703