Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Please help on this.
Below is my expression in in straight table for Rank.
=
Aggr(
rank(
(Round(sum({<[Safety Category]={'Green'}>} [Kms Travelled]) / sum([Kms Travelled]) *100)/4)
+(Round((COUNT(DISTINCT [DEVICE NO]) -COUNT([Device Number]))/COUNT(DISTINCT [DEVICE NO]) *100 )/4 ) +
(Round(SUM({<controlled={'Yes'}>}Quantity)/SUM({<controlled={'Yes'}+{'No'}>}Quantity)*100)/4)
+
(Round(SUM({<[iVMS ( Y/N)]={'Yes'}>}Quantity)/SUM({< [iVMS ( Y/N)]={'Yes'}+{'No'}>}Quantity)*100)/4)+sum([Kms Travelled])/(1E10)
,4,1),Group, [Carrier Name])
If i select this month in other expression it should be Previous Rank..
Please let me know if you want more info.
My selection should be only Carriername. Now its working fine with your suggestion with P().
Cool, I am glad it all worked out... Please mark any helpful responses (in addition to marking correct response you have already marked) in case there are any.
Best,
Sunny
Sure. I did. thanks for your great support
Thanks KUMAR