Using variable in SET Analysis

[pauljohansson]

Hi,

Im using a indirect Set Analysis where I want to select the Sum of deposits for the Customers that NOT are associated to the current selection. I also want to take into account a variable value. I get stuck when im combining selections and variable values in my indirect analysis SET.

My Base expressions - this works fine!

IF (vPaymentActivity = 'Payment Activity',
if(Sum(pmtAmount_EUR_Deposit)>=vPaymentAmount, Sum(pmtAmount_EUR_Deposit),),
Sum(
{<PaymentDate=E(PaymentDate),
pmtAmount_EUR_Deposit=E(pmtAmount_EUR_Deposit)>} pmtAmount_EUR_Deposit))

However, I want pmtAmount_EUR_Deposit do be dynamic, linked to a variable, NOT to the selection in the field. What I would assume to work is:

IF (vPaymentActivity = 'Payment Activity',
if(Sum(pmtAmount_EUR_Deposit)>=vPaymentAmount, Sum(pmtAmount_EUR_Deposit),),
Sum(
{<PaymentDate=E(PaymentDate),
pmtAmount_EUR_Deposit=E(>=$(vPaymentAmount)>} pmtAmount_EUR_Deposit))

To conclude:

Instead of referencing to the selections in field pmtAmount_EUR_Deposit, i want to reference to the vPaymentAmount.

Any advice are welcome,

thanks in advance,

br

Paul

[michael_maeuser]

try this

IF (vPaymentActivity = 'Payment Activity',
if(Sum(pmtAmount_EUR_Deposit)>=vPaymentAmount, Sum(pmtAmount_EUR_Deposit),),
Sum(
{<PaymentDate=E(PaymentDate),
pmtAmount_EUR_Deposit={'>=$(vPaymentAmount)'>} pmtAmount_EUR_Deposit))

[CELAMBARASAN · Accepted solution]

Use set analysis in E() function

Sum(
{<PaymentDate=E(PaymentDate),
pmtAmount_EUR_Deposit=E({<pmtAmount_EUR_Deposit = {">=$(vPaymentAmount)"}>} pmtAmount_EUR_Deposit)>} pmtAmount_EUR_Deposit)