Quick Set Analysis help....

[#1]

...Hi all,

Can someone help me by putting the following into some set analysis please?

I've been strugglnig with this all day and I'm officially stuck;

I would like to sum the field FUMValue where the RetMonthName and AUMMonthName are the same, these are how I've calculated the two month fields;

RetMonthName = MonthName(AddMonths([retired date]),-2))

AUMMonthName = MonthName(MonthYear)

I'm struggling with adapting the above to work within set analysis as I don't want to actually create the fields separately, can someone please help?

Kind Regards,

[mato32188]

Hi Samuel,

create a flag in script: if(RetMonthName = AUMMonthName, 1, 0) as @MonthEq

then

sum({<@MonthEq = {'1'}>}FUMValue)

BR

M

[JonnyPoole]

You can do it but you need a field context... for which field values are you making this comparison ? 

If it was for a ProductID for example use the SEARCH syntax (double quotes) with a preceding '=' sign before the condition. 

count( {$<ProductID={"=(MonthName(AddMonths([retired date]),-2)))=MonthName(MonthYear)"}>} ProductID)