Hi All-
Is there a way to use Advanced Options while in Text Mode? it only seems to work in Standard Mode.
Here is what I'm trying to do:
I have a Planned Hours column, an Actual Hours column, and a Remaining Hours column (which is Planned minus Actual). I then wanted to apply a rule so that if the value in the Remaining Hours column is negative, it will highlight the row. I can apply the rule while in Standard mode, but I don't see where I can apply the rule while in Text Mode.
Finally I'm trying to Sum the Remaining Hours column, but again, since I am in Text Mode, there does not appear ato be a way to do it.
Does anyone have any suggestions?
Thanks in advance.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
All of that is possible in text mode. The way I do it is to set up the conditional formatting rules in standard mode, then switch to text mode to make whatever changes can only be done in textmode. That way all the hard stuff carries over from standard to textmode.
You can also set up the rules in a temporary column in standard mode, then switch to text mode, and copy the relevant code to your permanent column.
Here is a helpful article: https://one.workfront.com/s/article/Using-Conditional-Formatting-in-Text-Mode-1570200200
Views
Replies
Total Likes
I can help out with one of your questions…Add the following to the "Remaining Hours" code from the Calculating Difference Between Planned and Actual Hours topic thread that I forwarded to you the other day…
aggregator.displayformat=minutesAsHoursString
aggregator.function=SUM
aggregator.namekey=workrequired
aggregator.valueexpression=ROUND(({workRequired}-{actualWorkRequired}),2)
aggregator.valueformat=val
This will sum the Remaining Hours column for you, but you'll also need to add/apply a Grouping to your report or view in order for the sum to render.
Views
Replies
Total Likes
Views
Replies
Total Likes
Hi Cory-
Thanks for the explanation. Unfortunately that doesn't seem to be working for me. Since the Remaining Hours column was a custom column, and not chosen from the list, it was never in Standard Mode, and if I try to create a temporary column, I have nothing to start with. This will likely be a problem when I do try to create a rule, since again, I am not able to select from the list. Any suggestions? Is there a way to save my Remaining Hours column to the list?
Views
Replies
Total Likes
Hi - yeah, you can't aggregate calculated columns.
This should help: https://one.workfront.com/s/article/Calculated-Custom-Fields-Vs-Calculated-Columns-280214936s
Views
Replies
Total Likes
Hi Chris,
Try this textmode. It should sum the remaining hours to parent tasks and highlight the row red if actual hours exceeds planned hours.
aggregator.displayformat=compound
aggregator.function=SUM
aggregator.valueexpression=ROUND(({workRequired}-{actualWorkRequired}),2)
aggregator.valueformat=compound
displayname=Remaining Hours
querysort=workRequired
row.0.styledef.applyallcases=true
row.0.styledef.case.0.comparison.icon=false
row.0.styledef.case.0.comparison.isrowcase=true
row.0.styledef.case.0.comparison.leftmethod=work
row.0.styledef.case.0.comparison.lefttext=work
row.0.styledef.case.0.comparison.operator=lt
row.0.styledef.case.0.comparison.operatortype=double
row.0.styledef.case.0.comparison.rightmethod=actualWork
row.0.styledef.case.0.comparison.righttext=actualWork
row.0.styledef.case.0.comparison.trueproperty.0.name=bgcolor
row.0.styledef.case.0.comparison.trueproperty.0.value=eac6c9
row.0.styledef.case.0.comparison.truetext=
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.isrowcase=true
styledef.case.0.comparison.leftmethod=work
styledef.case.0.comparison.lefttext=work
styledef.case.0.comparison.operator=lt
styledef.case.0.comparison.operatortype=double
styledef.case.0.comparison.rightmethod=actualWork
styledef.case.0.comparison.righttext=actualWork
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=
textmode=true
valueexpression=CONCAT(SUB({workRequired},{actualWorkRequired})/60, ' Hours')
valueformat=HTML
Views
Replies
Total Likes
Hey Cory-
That worked! I did change the first line to the following:
aggregator.displayformat=minutesAsHoursString
because it wasn't summing/displaying correctly in my Grouping
I can't thank you enough, and really appreciate you taking the time to work through it.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies