topic Re: set analysis in App Development

set analysis

JMAROUF — Sat, 16 Nov 2024 00:26:27 GMT

Hi everyone,

i want to sum sales of salers whose sales are equal to 10367007,4265, i have tried this:

=sum({1 <SalesPersonID={"=sum(SubTotal) =10367007,4265"}>} SubTotal)

but it doesn't work,

my goal is to understand advanced set analysis, can any one help please?

PS: it's possible with p() function?

Best regards.

Saravanan_Desingh — Sun, 14 Mar 2021 00:21:57 GMT

Try this,

=sum({<SalesPersonID={"=Match(sum(SubTotal),10367007,4265)"}>} SubTotal)

Denisg — Sun, 14 Mar 2021 00:53:03 GMT

Hi,
Or this one:
=Sum({<[SalesPersonID]={"=Sum(Distinct SubTotal)=10367007,4265"}>} SubTotal)

Vegar — Sun, 14 Mar 2021 09:41:58 GMT

It could be the decimal separator that is the issue.

Try changing from comma to dot for your comparison number, like this: 10367007.4265

JMAROUF — Sun, 14 Mar 2021 09:48:18 GMT

thank you for the reply, the the both solutions didn't work. here is my model, any help plezase.