DATE CALCULATION

[heitenfrozten]

Hi everyone :

I am stuck in trying to generate a final view just like "view.xlsx"  which is basically a graphic overview of  date calculation,  this model is to calculate the total attendance of a whole fleet by counting all the day that one unit was either shipped, in transit or returning to the  origin point.

I was able to make the general template but unfortunately I can not move forward to complete the 1 or 0 logic.

Could you help me?

Erick Castillo

[Qiu]

@heitenfrozten 
Can you kindly elaborate the meaning of 1 or 0?

[Raj]

why have you joined by position

I don't feel any logic in it

[Raj · Accepted solution]

i have generated logic according to my understanding and optained required result 

kindly go through it and make required changes

please let me know in case of any help

[heitenfrozten]

1 is a check that the unit (Trcuk) is in transit outbount or inbound

[heitenfrozten · Accepted solution]

This report allows me to support the accomplishment level in units (Trucks) allocated to my customer by counting either the shipments made by date and the units in transit.....

[heitenfrozten]

thnk you for helping me,,, this is what I was looking for