Pardon Peter,
Here are the correct formulas.
If formula
COUNT(distinct if([Date of Maintenance]>=[WORK_DAY],if(lastworkdate([Date of Maintenance], Round(([Days of Maintenance]/vDays),1))<=[WORK_DAY],[S/N])))* (METER * vConvert)
Set Analysis
count(distinct {$<WORK_DAY={"<=[Date of Maintenance] and >=lastworkdate([Date of Maintenance], Round(([Days of Maintenance]/vDays),1))"}>}[S/N]) * (METER * vConvert)
The results in first formula is correct, but takes longer as my dataset is big.
In this formula I have only the initial date of maintenance and last date. In chart, client is supposed to see all days from initial to last. That's why i had put <= and >=.
The dataset does not have these dates preload, either because user can change the Date of Maintenance and divide Days of Maintenance per another value.
Do you have any idea of how can I solve it through set analysis?
