opening sum

[sakamsureshbabu]

Hi All

in my requirement i required opening balance.That menace i want to calculate no.of personae are joined from starting of the scheme to before date of my selected Start date.

i am using below equation

=count(DISTINCT if((InvestDate>=Start and InvestDate<=End), MasterKey))

where Start  is selected Start date

          End  is selected End date

[Agis-Kalogiannis]

You can do something like this:

=count({$<InvestDate={'>=$(StartDate)<=$(EndDate)'}>}DISTINCT MasterKey)

And you can create two variables, StartDate and EndDate, and two Calendar objects that will modify the variable values.

Thanks

Agis

[sakamsureshbabu]

Hi

Thanks Agis.

[Agis-Kalogiannis]

Hi Suresh

Could you please mark the answer as helpful or correct if this is what you are looking for?

Thanks

Agis