Level 9

Solved

Calculate revenue on hrs report with rate from program

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by skyehansen

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)

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 : )

Level 9

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

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?

Level 9

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

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 : )

Sign up