I have a business case where I need to insert a special character such as a Check or X for the for a given value if the conditions are met.
this is obviously not the correct syntax for the expression but this is the concept I am trying solve.
If Submission date ="1" then "Special Character "X" + Submission Date" else Submission date endif
For reference I found this article on the message board which works great for replacing.
This is a example of how I would like it to look in the end.
The attached workflow has some dummy data to help kick off the process.
Thank you in advanced.
¡Resuelto! Ir a solución.
kinda there could be other rules where if the value is greater > some value then place special character such as below.
O.k. - so I think I have a dyanmic solution - but it's not pretty - could you post what you posted as an image as a .yxdb or .xlsx file? basically I can see a granular dynamic table with the magic of batch macro and render and then recreating that as a larger table.
also - can you confirm that non-zero values/a.k.a. red x can occur in any column?
and here's a slightly updated version
This would be my start - obviously the problems are - 1) we want individual cells not groups of them with the same vales. 2) how to join them. Developing solutions for 1) - 2) will require some summarize and some join tools.
so the short is it's doable. Assuming there is a lot of data - the individually rendered cells method could be worthwhile.
This look promising can you please share the workflow?
Thank you