Expand my Community achievements bar.

SOLVED

Calculate revenue on hrs report with rate from program

Avatar

Level 10

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

 

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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)

View solution in original post

8 Replies

Avatar

Community Advisor

Hmm, I'm not an expert in valueexpressions, but did you recalculate expressions on the objects you added this column to in the report?

If this helped you, please mark correct to help others : )

Avatar

Level 10

Thanks for the idea, Madalyn.  I tried that without any success.  It still doesn't produce a value in this calculated column.

Avatar

Community Advisor

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?

Avatar

Level 10

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

Avatar

Community Advisor

Looks like you have a parenths after billing rate instead of curly bracket, make it a curly bracket:

.{WF Program Billing Rate}

 

If this helped you, please mark correct to help others : )

Avatar

Correct answer by
Community Advisor

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)

Avatar

Community Advisor

Add DE: in front of your custom field - {DE:WF Program Billing Rate}

If this helped you, please mark correct to help others : )

Avatar

Level 10

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