Re: Build Logic to repetitive devices as 1, using loops/sum/count/if/set analysis
There was an error in calculation that I've corrected. I've included new QVW file as well as an Excel file that will help you understand the data scenario. You can compare information between Excel and QVW.
I hope explanation in word document will aid in understanding.
Data Model can be cleaned up and some additional/meaningful flag can be created for calculations.
KPIs and Expressions will have to be worked out using Set Analysis.