We have a List view using the Method for Workflow Reporting Service (List) : List Activity Instance Destinations and the Finish Date shows 1/1/1900. When I go into the view and attempt to create an expression to replace the 1/1/1900 to a null value the field is locked out and says I can't use it because of circular references.
Is there a way to make that show as null if it hasn't been updated ?
Best answer by CJack
I think a solution to this could be to add an additional Data Label column to the right or left of Finish Date column. Then add the expression you created to your new column (you could also title this column Finish Date) and hide the Finish Date column. This way your expression is looking at the old finish date column but updating the new one, now it won't be a circular reference.
Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such using the 'Mark as Solution', 'Kudos' andor ‘Me Too’ options.
I think a solution to this could be to add an additional Data Label column to the right or left of Finish Date column. Then add the expression you created to your new column (you could also title this column Finish Date) and hide the Finish Date column. This way your expression is looking at the old finish date column but updating the new one, now it won't be a circular reference.
Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such using the 'Mark as Solution', 'Kudos' andor ‘Me Too’ options.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
