Hello All,
I know there is a lot of solution available for the similar kind of problem and i tried most of them but seems like none of them is working in my case.
My Problem:
I want to create a Calculated Field TimeDiff which hold the TimeDiff for ( First Occurance Time for NEWVALUE = 602 ) and ( First Occurance Time for NEWVALUE = 202) for each NUMBER.
Jan 3, 2019 2:33 PM
Hello Shivam,
Did you locate a solution to this issue? If you could share a small bit of data in a packaged workbook, this appears to be fairly straight forward use of creating two new fields based upon the value of [NewValue] field for each [Number] and then using a view that does not include the New Value field so you then are able to utilize a datediff() function for the two new fields.
Please share a packaged workbook - Packaged workbooks: when, why, how
Thank you
Patrick