question

jschmidbauer avatar image
jschmidbauer asked

Percentage expression in Report Builder

I am new to this so apologize up front if I'm asking a question that doesn't belong in this forum or if it's incredibly simplistic in nature. I am trying to put together a matrix on labor charges. I have a field that tells me if the labor charge is direct or indirect. In my matrix, this is broken out in rows and is working correctly. I also have a row that provides a total for all direct and indirect labor charges. My columns are made up of the individual teams. What I need, though, is the percentage of indirect hours. In other words, each indirect 'cell' divided by each total 'cell'. Any help on this would be greatly appreciated!
sqlreportbuilder
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Mrs_Fatherjack avatar image
Mrs_Fatherjack answered
You need to add this as a calculation as you would in something like Excel, so in the cell you would build the calculation as an expression and do the calculation you have highlighted above.
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'm sorry for sounding dense, but I'm not understanding. In Excel, I can easily do this equation but am having no luck getting it to work in Report Builder. Here is the expression I have in place now, that isn't working: =IIF(Fields!LBR_TYPE_DESCR.Value = "INDIRECT" , Fields!RGLR_HRS.Value / Sum(Fields!RGLR_HRS.Value),"")
0 Likes 0 ·
What answer is that giving you?
0 Likes 0 ·
It isn't returning anything...the entire row stays blank....and I know that's not accurate. I've also checked to be sure I didn't need to trim the "INDIRECT" but that is fine.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.