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...

[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 · Accepted solution]

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

[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 :-)