Set Analysis Formula

[anthony_kinsell]

Hi,

I have the below formula as an expression:

Sum ({<FundHeading -= {'Residential Sales'}>} DevBudgetAmount)

I want to change the FundHeading to Right(FundHeading,5) but it doesn't seem as simple as :

Sum ({<IF(Right(FundHeading,5)) -= {'Sales'}>} DevBudgetAmount)

Anyone point me in the right direction?

[Nicole-Smith · Accepted solution]

Something like this:

sum({<FundHeading-={'*Sales'}>}DevBudgetAmount)

[MK_QSL]

Try Something Below

Sum ({<FundHeading -= {'=WildMatch(FundHeading, *Residential Sales*)'}>} DevBudgetAmount)

[#4]

Anthony,

Right(FundHeading, 5) is a dimension ? a valid field ?

if yes, try Sum({< $(=right(FundHeading, 5)) -= the rest of your set})

Fabrice

[simondachstr]

Try

Sum ({<FundHeading -= {'*Sales'}>} DevBudgetAmount)