Last 3 months in Set Analysis

[#1]

Good day

I have the following calculations on my set analysis:

sum({<L_WRITTEN_OFF_L3M_IND={'Y'}, L_CREDIT_DEBIT_IND={'DB'},L_NCA_PRODUCT_CODE={'UNL'}, L_NCA_IND={'J','Y','X'}>}[L WRITTEN OFF AMOUNT])

Now I want to use this set to calculate for the last three months.

Your assistance will be highly appreciated.

Kind regards,

Mbini

[mightyqlikers]

create a variable like vMonStart = monthstart(addmonths(datefield,-3))

vMonEnd = dateField

sum({<L_WRITTEN_OFF_L3M_IND={'Y'}, L_CREDIT_DEBIT_IND={'DB'},L_NCA_PRODUCT_CODE={'UNL'}, L_NCA_IND={'J','Y','X'},DateFeild ={'>=$(vMonStart ) <=$(vMonEnd )'}>}[L WRITTEN OFF AMOUNT])

Regards

$@M.

[Kushal_Chawda]

What is this Flag L_WRITTEN_OFF_L3M_IND?

[#4]

yes its a flag

[Kushal_Chawda]

So is this Last 3 months Flag?

[#6]

its a flag that checks if its been written off in the last three months

[#7]

my datefiled is 'Date'

[jonathandienst]

Define the variables: ( I always do this in the load, but you can use the variable overview as well):

Set vPeriodStart = '=AddMonths(Max(Date))';

Set vPeriodStart = '=AddMonths(Max(Date), -3)';

Set vPeriodEnd = '=Date(Max(Date))';

Then use the expression:

sum({<

  L_WRITTEN_OFF_L3M_IND={'Y'},

  L_CREDIT_DEBIT_IND={'DB'},

  L_NCA_PRODUCT_CODE={'UNL'},

  L_NCA_IND={'J','Y','X'},

  Date ={">=$(vPeriodStart) <=$(vPeriodEnd)'}>} [L WRITTEN OFF AMOUNT]

)

[#9]

Try this

sum({<L_WRITTEN_OFF_L3M_IND={'Y'}, L_CREDIT_DEBIT_IND={'DB'},L_NCA_PRODUCT_CODE={'UNL'},L_NCA_IND={'J','Y','X'},DATEFIELD={">=$(=MonthStart(max(DATEFIELD),-3))<=$(=max(DATEFIELD))"}>}[L WRITTEN OFF AMOUNT])

[#10]

I have tried this, I get a negative value