Expense Text Mode on Task Report

[Stacey_Robertson]

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

[RowvillBh1]

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

[Stacey_Robertson]

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

[RowvillBh1]

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. 

[Stacey_Robertson]

The expenses are entered on the task.

[skyehansen]

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.