Text Mode Error for Column Addition?

[DavidRu1]

Capital Budget Project Report: I can get two columns to add up, but not the third. Can anyone spot my error?

[DavidRu1]

bump Dave Rulon Great Dane Savannah, GA 912-644-2452

[TerryHy]

Try this...

displayname=

linkedname=direct

namekey=Capital Budget

querysort=DE:Capital Budget

valuefield=Capital Budget

valueformat=customNumberAsCurrencyStringRounded

aggregator.function=SUM

aggregator.valuefield=DE:Capital Budget

aggregator.namekey=Capital Budget

aggregator.displayformat=customNumberAsCurrencyStringRounded

Terry Hynd EBSCO Information Services

[DavidRu1]

Thank you for the response. But unfortunately, it didn't work. Dave Rulon Great Dane Savannah, GA 912-644-2452

[AnthonyIm]

Hi - did you confirm that your custom field for Capital Budget is a number field and not a Text field? I've done that before and that means you can't do SUM. Anthony Imgrund FCB

[DavidRu1]

DING! DING! DING! We have a Winner! Thank you very much!! That was driving me crazy! Maybe I can figure it out now. (Hopefully) Dave Rulon Great Dane Savannah, GA 912-644-2452

[EXP_-_DustinMa]

Anthony is spot on! You can rename the field, recreate it, changing only the format, and you should be all set to go. Best of luck! Dustin Martin Assigned Support Engineer Workfront

[DavidRu1]

Dave Rulon Great Dane Savannah, GA 912-644-2452