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.
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)
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
Thank you, Sam
I will try.
You're welcome, Nick :)
Hope it helps you!
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
You're welcome, Hayasaka :)
I'm happy that the suggested solution helped you :)