Expense Text Mode on Task Report | Community
Skip to main content
S
Stacey_Robertson
Level 5
November 3, 2025
Question

Expense Text Mode on Task Report

  • November 3, 2025
  • 2 replies
  • 250 views

I have the following text mode working on a project report but I need to create a task report with the same column. If anyone can help adapt the text mode to work from a task report it would be much appreciated.

aggregator.displayformat=currencyStringCurrency
aggregator.function=SUM
aggregator.valuefield=actualAmount
aggregator.valueformat=doubleAsDouble
descriptionkey=actualamount
listsort=doubleAsDouble(actualAmount)
namekey=actualamount
querysort=actualAmount
shortview=true
stretch=100
styledef.comparison.leftmethod=double(actualAmount)
styledef.comparison.operator=gt
styledef.comparison.operatortype=double
styledef.comparison.rightmethod=double(plannedAmount)
styledef.comparison.truetext=font-weight:900;color:#990000;
valuefield=actualAmount
valueformat=currencyStringCurrency
width=100

2 replies

RowvillBh1
RowvillBh1
Level 5
November 3, 2025

Hi @stacey_robertson What issue are you facing when you try the same code on a task report?

S
Stacey_RobertsonAuthor
Level 5
November 3, 2025

It is comng up with no amounts, but there are amounts on the project report.

RowvillBh1
RowvillBh1
Level 5
November 3, 2025

Are you trying to pull the amount from your project level on the task level? or do you have this amount filled out differently for each task. 

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
November 4, 2025

I'm not able to get your text mode above working on a project report. For me, it only works on an expense report.

 

If I had to guess, I would say you probably have an expense report that is grouping by project. If you wanted the same thing grouped by task, I would advise that you can copy your original report and change the copy so that it groups by task instead.

Terms & ConditionsAccessibility statement

Loading footer...