Help with Percentage formula

[DanijelaS]

Hi,

I need help with percentage formula. The formula created is not working properly. Please see below example:

For example:

Project # Hours Percentage
Project A 8
Project B 10
Project C 12

Total Client 30 100%

(100 % is what it should be but my formula is picking the last record which is 12/30 40%)


(Both Project and Client are parameters on this Report.)


The formula used:
Sum ({Transact.Hours}, {Project.Number}) % Sum ({Transact.Hours}, {Client.Number})

 

[IanWaterman]

Formula is doing precisely what you have asked it and showing value of last project group.

If you want to see 100% you will need to change formula to

The formula used:
Sum ({Transact.Hours}, {Client.Number}) % Sum ({Transact.Hours}, {Client.Number})

Ian

 

[DanijelaS]

Thank you Ian!

But when I am running the report for only Project A then the percentage should be only (8/30) 26.67%.

If I used only Client for parameters than the formula you have suggested would work perfectly.

Thanks!

 

[IanWaterman]

But as you say that is the Project amount. If you filter data for only Project A it will be 100% of the records for That client.

If you want to see project A as 26.67% then you must use your original formula in Project group footer.

Alternatively you will need to use Group suppression. This will then suppress the display of the other projects but keep the data however, total for client will still be 100%. But you will only see Project A listed at 26.67%.

Ian

 

[lbass]

The issue is that you need two different formulas, since you are evaluating at two different group levels. Your original formula will work for your inner group, and Ian's formula will work for the outer group.

-LB