Hi WF Community,
I thought the following would be a fairly simple task for me, but I'm struggling to get the result I desire.
Goal: have a calculated column called "Actual Monthly Revenue" on an hours report that derives a value from the following calculation:
- valueexpression={hours}*{project}.{program}.{DE:WF Program Billing Rate}
I'm simply multiplying individual hours by a currency value at the program level.
Am I missing something?
Thanks,
Nick
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
I'm not getting blanks on my side. Your original expression worked.
displayname=
textmode=true
valueexpression={hours}*{project}.{program}.{DE:my field name here}
valueformat=currencyStringCurrency
Maybe try deleting the column and putting it in one more time from scratch? (or making a new report for kicks)
Views
Replies
Total Likes
Hmm, I'm not an expert in valueexpressions, but did you recalculate expressions on the objects you added this column to in the report?
Views
Replies
Total Likes
Thanks for the idea, Madalyn. I tried that without any success. It still doesn't produce a value in this calculated column.
Views
Replies
Total Likes
Works on my side.
* Your billing rate was formatted as a number, right?
* What result are you getting that is undesired?
* What does the rest of your column look like?
Views
Replies
Total Likes
Hey Skye!
1. Billing Rate is formatted as Currency
2. The undesired result is blanks (nothing appearing in the calculated column)
3. Here's the full text mode for that calculated column (Actual Monthly Revenue)
displayname=Actual Monthly Revenue
textmode=true
valueexpression={hours}*{project}.{WF Program Billing Rate)
valueformat=currencyStringCurrency
Views
Replies
Total Likes
Looks like you have a parenths after billing rate instead of curly bracket, make it a curly bracket:
.{WF Program Billing Rate}
Views
Replies
Total Likes
I'm not getting blanks on my side. Your original expression worked.
displayname=
textmode=true
valueexpression={hours}*{project}.{program}.{DE:my field name here}
valueformat=currencyStringCurrency
Maybe try deleting the column and putting it in one more time from scratch? (or making a new report for kicks)
Views
Replies
Total Likes
Add DE: in front of your custom field - {DE:WF Program Billing Rate}
Views
Replies
Total Likes
Thanks for the suggestions, Madalyn and Skye! I had tried those without success in the many iterations of text mode. You know what ended up working? Creating a brand new column, per Skye's suggestion, and using this iteration:
displayname=Actual Monthly Revenue
textmode=true
valueexpression={hours}*{project}.{program}.{DE:WF Program Billing Rate}
valueformat=currencyStringCurrency
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies