Advanced Options Not Available in Text Mode?

[ChrisLe5]

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.

[CoryAn]

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

[TerryHy]

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.

[ChrisLe5]

Thanks Terry...that worked perfectly. I appreciate it. Chris Levitsky Guidemark

[ChrisLe5]

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?

[AnthonyIm]

Hi - yeah, you can't aggregate calculated columns.

This should help: https://one.workfront.com/s/article/Calculated-Custom-Fields-Vs-Calculated-Columns-280214936s

[CoryAn]

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

[ChrisLe5]

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.