Need how long something took in minutes

[lonnie.lee]

Hoping this will be a easy question. All I am wanting to do is show how long it took to complete each process. For some reason all results come back null or at least seem that way.

If I do not allow null it will bring back no records.

Here is another one that works.

I am new to Dundas BTW. I have full rights so I can trouble shoot anything including the source data of the sql server. I am not sure where to start looking for the issue.

Thanks Lonnie

[lonnie.lee]

Found my error
($End_Time$.MemberTime - $Start_Time$.MemberTime).TotalMinutes Instead of ($End_Time$.MemberTime - $Start_Time$.MemberTime).TimeTook <–

Thanks

[jeff (Jeff Hainsworth)]

Thanks for posting your solution Lonnie