sum after the first deposit this month

[shai2127]

Hey,

I want to sum the volume only after the first deposit that happened from 03/09/2019. if the client traded before his first deposit this month I don't want to count it, only after.

this is the sum of the volume formula: 

=Sum({<Date_Type={'CLOSE_DATE'},CONV_RATE1={">0"},SYMBOL-={'Zeroing' ,'ZeroingEUR' ,'fee' ,'FEE' ,'CorrectiEUR' ,'Correction' ,''}>}[Trade_Volume_Close])

the first deposit date formula:

= min({1< [approval_date]={"<=25/09/2019"}
,[approval_date]={">=03/09/2019"},country_name={'South Africa'}
,Transactions_type]={'1'},Comb_Owner_Type={ 'Transaction_Owner'} >} approval_date)

please help me combined  them

[Yoshidaqlik]

Hi

try:

SUM(
	Aggr(
		if(
			min({1< [approval_date]={"<=25/09/2019"}
			,[approval_date]={">=03/09/2019"},country_name={'South Africa'}
			,Transactions_type]={'1'},Comb_Owner_Type={ 'Transaction_Owner'} >} approval_date
			) >=DATE#('03/09/2019','DD/MM/YYYY'),
			Sum({<Date_Type={'CLOSE_DATE'},CONV_RATE1={">0"},SYMBOL-={'Zeroing' ,'ZeroingEUR' ,'fee' ,'FEE' ,'CorrectiEUR' ,'Correction' ,''}>}[Trade_Volume_Close])
		)
	,Customer)
)

Regards