How can we convert milliseconds to seconds?

[monicateja]

Hi,

How can we calculate milli seconds to seconds for this field -> transactionDuration=20058?

[monicateja]

Do we need to convert duration_secs? 

duration_secs=ROUND(transactionDuration/1000, 2

[johnhuang]

Sorry I realized there's a typo in my initial solution.

| eval duration_secs=ROUND(transactionDuration/1000, 2)

[johnhuang]

| duration_secs=ROUND(transactionDuration/1000, 2)