Calculate revenue on hrs report with rate from program

[NickVa1]

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

[Madalyn_Destafney]

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

[NickVa1]

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

[skyehansen]

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?

[NickVa1]

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

[Madalyn_Destafney]

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

.{WF Program Billing Rate}

[skyehansen · Accepted solution]

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)

[Madalyn_Destafney]

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

[NickVa1]

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