Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Can text mode columns contain filter

Avatar

Level 3

Can I add a filter to a column in text mode to show and sum labor between a specified period? i.e. 2018 portion of a multi-year project

I want to only show the portion of active projects Budgeted Labor Costs that will run over into 2018 for a report. I don't want the estimated labor planned for 2017 to show.

Budget Labor Cost

linkedname=direct

namekey=budgetedLaborCost

querysort=budgetedLaborCost

textmode=false

valuefield=budgetedLaborCost

valueformat=currencyStringCurrencyRounded

Looking at this filter that I know won't work:

allocationDate=$$TODAYby+1

allocationDate_Mod=between

allocationDate_Range=$$TODAYey+1

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies

Avatar

Level 3

0690z000008K977AAC.pngProject Planning Budget Review David Allingham Reed Technology and Information Services Inc.

Avatar

Level 10
I believe you would have to do that in the Filters tab of your report. You can do Text Mode there too. Vic Alejandro, PMP, CSM | IT | Sr. IT Project Manager Denver Water | t: 303-628-7262 | c: 303-319-6473 "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

Avatar

Level 4
Hi David, You might want to check out "https://support.workfront.com/hc/en-us/articles/216652818-Using-Calculated-Custom-Data">calculated custom data . You can conditionally set a value for the project and then sum it up on the report. There is some helpful discussion about this in the Advanced Reporting course manual. Daniel Cooley Kenall