Help Converting RunningValue AVG to Percentage

Question

Hi,

I have a RunningValue AVG on a group in a Matrix report and the client wants this represented as a percent. Below is my RunningValue expression:

=FORMAT(RunningValue(Fields!NoGoLive.Value ,AVG,"FYQuarter1"), "N2")

NoGoLive is AVG over my quarter group called FYQuarter1. Any help is appreciated!

Thanks

---

Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

Answer 1

What is the data type of the field NoGoLive?  integer? decimal?

Answer 2

Integer

---

Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

Answer 3

Hi There

Thanks for your posting. You can right click on your textbox and go to the properties and set the format property like this

0%;(0%)

0%;(0%)

Or on the other way if you are using SSRS 2008 you can right click on the textbox and go to properties and then go to tab and set the format as percentage.

 If you have any question please let me know.

Many Thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 4

Hello,

Please refer to the following expression:

=FORMAT(RunningValue(Fields!NoGoLive.Value ,AVG,"FYQuarter1")/100, "P2").

Or you can the steps as Syed posted above to format the textbox property.

If you have any question, please feel free to ask.

Regards,

Fanny Liu

If you have any feedback on our support, please click here .

---

Fanny Liu
TechNet Community Support

Answer 5

Thanks for your responses - both Syed's and Fanny's solutions worked perfectly.

Thank You!!!

---

Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends