1 of 1 people found this helpful
The question is How to define the period of "Remove"
Because actually period of remove, that server is still in service and next period is the real timing of removal.
But because there is not data, cannot count "null".
So I recommend that you back-calculate "Removed"
"Count of Server" - "Count of server last period" - "Newly added"
[Removed Servers (calc)]
countd([Server Name])-lookup(countd([Server Name]),-1)-[Added Servers]
[Net Service (Calc)]
[Added Servers]+[Removed Servers (calc)]
Thank you Shin this worked like a champ! Greatly appreciated!
You are welcome.