topic Re: Sum with conditions. in App Development

Sum with conditions.

FinancialDataScientist — Thu, 01 Apr 2021 13:46:08 GMT

Hi all,

I'm new to this forum so apologies in advance if I've posted this question in the wrong place.

I'm trying to create a formula where I add up the vAggMeasure only if CC_Quartile is equal to either 1,2,3 or 4. This is the formula I have so far:

Sum(TOTAL <[ProjectName]> aggr({<CC_Quartile='={1,2,3,4}'>} $(vAggMeasure), [ProjectName], [FundName]))

However, the total which is computed using this formula includes instances where 'CC_Quartile' is a blank ('-' in QS).

Does anyone know how I can fix this?

Lisa_P — Sun, 24 Jan 2021 22:06:13 GMT

Try this:

Sum(TOTAL <[ProjectName]> aggr({<CC_Quartile={1,2,3,4}>} $(vAggMeasure), [ProjectName], [FundName]))

FinancialDataScientist — Sun, 24 Jan 2021 22:11:44 GMT

Thanks for coming back so quickly. Unfortunately, I’ve tried this formula and am still having the same issue.

Ksrinivasan — Mon, 25 Jan 2021 03:09:49 GMT

hi,

Sum(TOTAL <[ProjectName]> aggr({<CC_Quartile='={1,2,3,4}'>} $(vAggMeasure), [ProjectName], [FundName]))

try this
(Sum({$<CC_Quartile = {'1','2','3','4'}>} Total AggMeasure))

ksrinivasan.

FinancialDataScientist — Mon, 25 Jan 2021 18:42:34 GMT

Thanks all.