Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
Hi all,
I have a requirement where there are 2 fields of an infotable say data1 (basetype infotable) and data2(basetype infotable).
Now I need to create an infotable which is as such data1-data2
That is the elements of data2 must be subtracted from data1 and the result must be in answer.
How to achieve it?
Solved! Go to Solution.
You should do something like this:
var result = Resources["InfoTableFunctions"].DeriveFields({
t: myInfotable,
types: "LONG",
columns: "differenceInMilliseconds",
expressions: "dateDifference(data1,data2);"
});
Hi, keep in mind that datetime is calculated in milliseconds, so you can use that for your math logic and then output the result in the datetime format again.
You should do something like this:
var result = Resources["InfoTableFunctions"].DeriveFields({
t: myInfotable,
types: "LONG",
columns: "differenceInMilliseconds",
expressions: "dateDifference(data1,data2);"
});
Thanks a ton! It worked