Count changing form month to month

[Anonymous]

Hello All,

I am facing issue count of employees. I generated the report on 27-03-17 for the month of February data and the number is 16448 and I generated the report today for the month of February and the number increased to 16622. How can we make the number constant to 16448 forever. Looking forward for suggestions.

Regards,

Ram.

[luismadriz]

Hi Ram, your count shouldn't change for the same month but of course this depends on the calculation or if new data is being added for that period. Can you please share a bit more on the data or the calculation?

Regards,

L

[Anil_Babu_Samineni]

You can restrict the data using set analysis

Sum({<DateField = {'<= 27-03-17'}>} Measure)

[its_anandrjs]

May be you can use because data is get increases in the transaction table due to this. Better find the reason also with joins it happen or what.

=Count( DISTINCT employees)

[Anonymous]

Hello Luis,

Thanks for your prompt response. Below is the calculation formula

Count({$<_TransSubType={'CONTRACT','JOINERS'},%INSURANCE_TYPE_CODE={'1'},_YearMonth={'$(vCurrentMonth)'},Month=,Year=,[Month AR]=>} DISTINCT %COMPANY_NUMBER)

vCurrentMonth= =max(_YearMonth)

Regards,

Ram

[Anonymous]

Hello Anand,

I have replied with the calculation formula. Please check it.

regards,

Ram

[Anonymous]

Hi Anil,

Date is dynamic, User can select any day, but the count should be fix

Regards,

Ram

[Anil_Babu_Samineni]

Does this helps you?

Sum({<DateField = {"$(=GetFieldSelection(DateField))"}>} Measure)

OR

Sum({<DateField = {$(Concat(Chr(39) & DateField & Chr(39), ','))}>} Measure)

[Anonymous]

Hello Anil,

calculation formula is: Count({$<_TransSubType={'CONTRACT','JOINERS'},%INSURANCE_TYPE_CODE={'1'},_YearMonth={'$(vCurrentMonth)'},Month=,Year=,[Month AR]=>} DISTINCT %COMPANY_NUMBER)

vCurrentMonth= =max(_YearMonth)

Suggest me what changes required on this formula to make count constant.

Ragards,

Ram

[Anil_Babu_Samineni]

That means, You want to count till 27-03-17 ??