Calculation mismatch

[#1]

Hi,

I have 2 charts. I have written the same expression on both the charts for (FTE allocated - green). however, once i select any division, the number of FTE allocated on both the chart differs. Ideally FTE allocated should be a straight line (in chart1) and should be equal to the FTE allocated shown in chart 2.......for eg:with current selection, in chart1 i should have 2.13 as a stright line for FTE allocated.

Any help on this would be appreciated.

[Gysbert_Wassenaar]

Try this:

=if(getselectedcount(Division)=1,Sum(Total [Time to complete])/Sum({<Division=>}Total [Time to complete])*Sum(Resource),sum(Resource))

[#3]

can you please guide me more here..seems i m lost...

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#5]

thanks a ton

[#6]

the only error that i can see now is that these 2 charts are woeking perfectly with alul listboxes but it gives an incorrect output only when i select an option from industry and dont selecet any field from the other listboxes,

if i select one more value from another listbox, output comes correct. so the problem is only selecting an option from industry on standalone basis.

attached for your refrence.

can you please help.