Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate Count Between Two Dates - Incorrect on Higher Level of Date Hierarchy

Hi all,   I am trying to create a report which shows number of employee terminations during parental leave. My model is below.           Employee and TimeOffRequest SF tables are joine...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

Change the direction between table "Employee" and "TimeOffRequestSF" from single to both and check if the result is as your expected result.

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the reply v-yuta-msft . Unfortunately, changing to Both direction does not change anything. Still giving the same wrong result. :(