Jun 23, 2011 11:29 AM|MSBoston|LINK
I'm having a minor issue at the moment with getting one of my cells to display a fractional result instead of a decimal or percentage.
So I'm looking for something like...
TotalAwards / TotalPeople (ex. 130 / 140)
The actual expression for the cell is...
=Count(Fields!FullName.Value) / Lookup(Fields!ServiceName.Value, Fields!ServiceName.Value, Fields!TotalPeople.Value, "TotalPeople")
So I cannot just go to the design view and type in [Count(FullName)] / [Lookup(ServiceName,ServiceName,TotalPeople,"TotalPeople")], instead I believe my solution will probably come from using the custom formatting of the cell (keep in mind
that "# ???/???" or "###/###" do not work as custom formats.)
Could anyone help me with this?