sql expression in qlikview

[#1]

Hi Experts,

i have the below expressions in sql.

Drops% =Fields!Drops.Value/Sum(Fields!Drops.Value, "Driver")

Run Time :  = (

IIF(Fields!Time.Value\60 < 10, "0" + CStr(Fields!Time.Value\60), CStr(Fields!Time.Value\60))

+ ":" +

IIF(Fields!Time.Value mod 60 < 10, "0" + FormatNumber(Fields!Time.Value mod 60,0), FormatNumber(Fields!Time.Value mod 60,0))

)

In Qlikview, Drops is calculated as below

Drops: sum(aggr(count(DISTINCT customer),ORDERNO))

how can i calculate above (sql) Drops% & Run Time in qlikview.

Please help

[Gysbert_Wassenaar]

Run Time: Time(Fields!Time.Value/86400, 'mm:ss')

[#3 · Accepted solution]

Run time: interval(sum(time)/24/60,'hh:mm')