How to Sum with more than 1 condition
Application Type
Mobile

Hello Everyone,

can you help me with my problem?

I have a table, I want to do Sum but with the condition ( Column "Booth" not Charity Center).

Thank you very much.

Screenshot20210318140002.png

mvp_badge
MVP

Hi Nick,

you can add filter based on Booth Column like

Booth<>"Charity Center "


Hope this will help you.

Regards

Rahul

yes, but also I want to show the remand amount of money they have in hand as well.

i want to calculate the After tax = ( PriceSum *10%)

PriceSum ( with out Charity Center)

Screenshot20210318142228.png

mvp_badge
MVP

Hi Nick,

For the mentioned requirment. You will have to 

Steps to follow:

1) Group by Player.Name column

2) Add Filter Condition

ToLower(Trim(ActionCode.Booth)) <> "charity center" // avoid hardcoded value, instead create & reference static entity attribute vlaue

3) Introduce an ad-hoc column/attribute (by adding + New attribute link) and define the calculate attribute expression value as

ActionCode.Price * 0.10

4) Define the Aggregate Sum to the newly introduce ad-hoc column

5) You can now access the Player.Name & ad-hoc attribute value wherever it's required.

That's it!


Hope this helps you!


Kind regards,

Benjith Sam

mvp_badge
MVP

You're welcome, Nick :)

Hope it helps you!


Kind regards,

Benjith Sam

Hi Sam, I'm calculating like this. But no filter.I achieved Total(10%Tax Inclusive) database dynamically by referencing your comment.

It helped me. 

Always Thanks

Hayasaka


mvp_badge
MVP

You're welcome, Hayasaka :)

I'm happy that the suggested solution helped you :)


Kind regards,

Benjith Sam

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.