topic Re: Multiple step expression in App Development

Multiple step expression

brucemeyers — Wed, 28 Nov 2018 03:05:10 GMT

I want to make the expression below perform these calculations

Sum the [Costs] of the [Soup Brand] field containing ‘Whole Foods’

Sum the [Costs] of the [Soup Brand] field containing ‘Nissin Cup Noodles’, ‘Health Valley’, and ‘Healthy Choice’

Sum the [Costs] of the [Soup Brand] field containing ‘Campbells’ and ‘Progresso’

Here is what I have come up with but I need help

Sum({1<[ Soup Brand]={'Whole Foods '}> -

1<[ Soup Brand]={'Nissin Cup Noodles '}> + 1<[ Soup Brand]={'Health Valley '}> + 1<[ Soup Brand]={'Healthy Choice '}> -

1<[ Soup Brand]={'Campbells '}> + 1<[ Soup Brand]={' Progresso '}>

} [Cost])

Re: Multiple step expression

MohammedMustaq — Wed, 28 Nov 2018 06:49:38 GMT

Try this:

=(Sum({<[Soup Brand]={'Whole Foods'}>}[Cost])-Sum({<[Soup Brand]={'Nissin Cup Noodles'}>}[Cost])
+Sum({<[Soup Brand]={'Health Valley','Healthy Choice'}>} [Cost])
-Sum({<[Soup Brand]={'Campbells'}>}[Cost])+ Sum({<[Soup Brand]={'Progresso'}>}[Cost]))

Regards

Mohammmed Mustaq

Re: Multiple step expression

shitijar — Wed, 28 Nov 2018 06:57:16 GMT

Hi,

Instead of writing three different expressions of Soup brands you can club it in one single expression right.

1<[ Soup Brand]={'Nissin Cup Noodles ', 'Health Valley ', 'Healthy Choice '}>

Thanks,

Shetty

Re: Multiple step expression

MohammedMustaq — Wed, 28 Nov 2018 07:11:59 GMT

I hope i understand your requirement.

With Your Set Analysis Expression:

=(Sum({<[ Soup Brand]={'Whole Foods','Health Valley','Healthy Choice','Progresso'}>} [Cost])

-Sum({<[ Soup Brand]={'Nissin Cup Noodles','Campbells'}>} [Cost]))

Logic:

Whole Foods+Healthy Valley+Healthy Choice+Progresso -Nissin Cup Noodles and Campbells

Re: Multiple step expression

brucemeyers — Wed, 28 Nov 2018 12:40:05 GMT

Logic:

Sum(Whole Foods) - Sum(Healthy Valley+Healthy Choice+Nissin Cup Noodles) - Sum (Progresso + Campbells)

Re: Multiple step expression

MohammedMustaq — Wed, 28 Nov 2018 16:34:32 GMT

Try this:

=Sum({<[Soup Brand]={'Whole Foods'}>}[Cost])

-Sum({<[Soup Brand]={'Health Valley','Healthy Choice','Nissin Cup Noodles'}>}[Cost])

-Sum({<[Soup Brand] ={'Progresso','Campbells'}>}[Cost])

Thanks