I want to find the diff time in each row.

[Paknanarn23]

I want to subtract the value of the first column in each Wo_KCEPart, what should I do?

[Aditya_Chitale]

didn't understand your question. Need more clearity. You want to subtract value of first column from what ? As far as I am seeing, Wo_KCEPart column contains text values.

Regards,

Aditya

[Paknanarn23]

I want to subtract the times of the DATE TIME fields, for example 2023-06-15 07:06:17 and 2023-06-15 07:06:17 of each Wo_KCEPart.

[Aditya_Chitale]

Can you provide sample data and expected output ? You can jumble up the numbers if you have security concern.

Regards,

Aditya

[Paknanarn23]

For example, I took the value 06/15/2023 08:19 - 06/15/2023 11:15 to get 02:56:11.

[Aditya_Chitale]

In your fact  table script,  use this :

"New DateTime" - peek('New DateTime',RowNo(),'data')  as  "DateTime Diff"

Sample Data used:

Output:

Hope this is what you were looking for.

Regards,

Aditya