Same value appearing for all the Rows

[bharani8]

Hi Experts,

I have created a simple Straight table.. My Total value is showing right and When i click on one particular Reporting month, still the numbers are fine. Problem arises when i click on couple of months or more than that... It shows the same value for all the reporting month.. Not sure where i need to tweak.. I have created with few Variables.. and have demonstrated clearly.. Please help me to get the right values for each and every Reporting month..Attached files FYR..

[avinashelite]

Hi

try this expression and let me know if it gives the rite results

=(Fractile(sotat,.9)-1+(Count(SCHEDULE_LOGIC)*.9+count({<sotat = {"=(Fractile(sotat,.9))"}>} SCHEDULE_LOGIC)))/count({<sotat = {"=(Fractile(sotat,.9))"}>} SCHEDULE_LOGIC)

[bharani8]

I See different numbers.. But result is wrong for all the months .. Even Total is wrong

[avinashelite]

Ok whats the number your excepting ? could you show the values for each month

[bharani8]

Nov - 1.83

Dec - 1.91

Jan - 2.71

Total - 2.03

[bharani8]

Any luck Avinash ?