
1. Re: Nested DateDiff Function
Kaz Shakir Mar 29, 2017 1:20 PM (in response to mozammel chowdhury)Mozammel,
What is that function supposed to be calculating? The inner DateDiff, seems to be calculating the number of minutes between [ARSiteTM] and [DTSiteTM]; and then dividing that number by 60 which would produce the number of hours (or fractions of an hour) that have elapsed between those times. Now, that result is going into the outer DateDiff as the third argument  but the third argument is supposed to be a date value, and this is just a number of hours. And so, it doesn't really make any sense to me as to how you can find the difference between [Lunch Taken] (which I presume is a datetime value) and just a number of hours value.
Are you trying to find the amount of time elapsed between [Lunch Taken] and the later of [ARSiteTM] and [DTSiteTM]? If so, you could do a comparison of those fileds and just take the one that has the higher value; or viceversa if you are trying to do the opposite.
If you can provide a little more detail about your goal, we might be able to come up with some ideas for you.
Kaz.

2. Re: Nested DateDiff Function
mozammel chowdhury Mar 29, 2017 1:54 PM (in response to Kaz Shakir)Thanks KAZ,
Essentially [Lunch Taken] ,[ ARSiteTM ]and [ DTSiteTM] are all datefields. So the goal is to get the actual time worked. So AR site is the start time of work, DT site is the end time of work. Then [Lunch Break] is formatted as an hour format instead of int showing how much should be excluded from the total work. So I am not sure what I can do here. Let me know if you need additional clarification.

3. Re: Nested DateDiff Function
Kaz Shakir Mar 29, 2017 2:29 PM (in response to mozammel chowdhury)In Tableau, can't you just do simple math, like this:
AllHoursAtWork
[DTSiteTM]  [ARSiteTM]
AllHoursWorking
[AllHoursAtWork]  [Lunch Taken]
?
Would something that simple work?
Kaz.