How to solve the Rank for same %

[rkpatelqlikview]

Hi,

Please help on this.

I am struggling here to solve this ranking. If i get  a same rank it should compare with another field(filed name is [Vehicle Number] based on the count vehicles. How can i include this one in  my expression to resolve the same rank?

This is the expression for Rank i have given in the Straight table:

=aggr(rank(rangesum((Ceil(SUM({<[Control_Fleet (Y/N)]={'Yes'}>}Quantity)/SUM({<[Control_Fleet (Y/N)]={'Yes'}+{'No'}>}Quantity)*100,0.01,0) /4)

+

(Ceil(SUM({<[iVMS ( Y/N)]={'Yes'}>}Quantity)/SUM({<[iVMS ( Y/N)]={'Yes'}+{'No'}>}Quantity)*100,0.1,0)/4 )

+

(ceil(sum({<[Safe KM driven Classification]={'Green'}>} [Kms Travelled])/sum([Kms Travelled]) *100,0.1,0) /4 )

+

(round((Count(DISTINCT [Vehicle Number]) - Count(DISTINCT {<Status1 = {"$(='>=' & Date(Today() - 7))"}>} [Vehicle Number]))/Count (DISTINCT [Vehicle Number]) *100, 0.01,0)/4)),  1,1), [Carrier Name])

Thanks

KUMAR.

[sunny_talwar]

Would you be able to share a sample to check this out?

[rkpatelqlikview]

Thanks for your reply Sunny,

Sure.

Please find the attached data. When user enter the Carrier name it should show the Rank of among their group (No.of vehicles).

If suppose the group1 no of fleets are 172 then that particular Carrier rank should be compare with that group1.

Rank of transporter  current Rank 8/172 and Previous Rank 7/172..

Please let me know if you want any other data.

Please help on this.

Thanks again.

[rkpatelqlikview]

I need to show this rank in Text Object