Beatrix
06-09-2016, 03:43 AM
Hi Everyone
I need your help please.
I use below formula in Access SQL. First format function calculates the percentage by using 2 fields and second format function is supposed to return the value as 100% which seems it does however when I sort the list based on percentage then 100.00% comes after 10.00%.
First format function is working ok but second one doesn't even the outcome looks like 100.00%
IIF(TotalAbsence>0,Format((1-(TotalAbsence/TotalSessionsPossible)),'#.##%'),Format((1),'Percent'))
Can you help me on this please??
Cheers
B.
I need your help please.
I use below formula in Access SQL. First format function calculates the percentage by using 2 fields and second format function is supposed to return the value as 100% which seems it does however when I sort the list based on percentage then 100.00% comes after 10.00%.
First format function is working ok but second one doesn't even the outcome looks like 100.00%
IIF(TotalAbsence>0,Format((1-(TotalAbsence/TotalSessionsPossible)),'#.##%'),Format((1),'Percent'))
Can you help me on this please??
Cheers
B.