How to filter gallery from dropdown and sum the grand total

[sarfika]

Hai, when the "contract number" selected, the Contract utilization will calculated based on the sum of "total after sst" on grand total column. But the gallery not filter based on the contract number selected. Kindly help me on this. Thankyou

You can refer the attachment for more info

[NandiniBhagya20 · Accepted solution]

Hi @sarfika ,

In Items property of your gallery you will have to use below formula - 

Filter(Cart, IsBlank(DropdownControlNameWithContractNumber.Selected.Value) || 'Contract Number'=DropdownControlNameWithContractNumber.Selected.Value)

[sarfika]

Thank you for the solution, but why sometime the total in Contract utilization appear and sometime not?

[NandiniBhagya20]

Instead of writing the formula in OnChnage event of dropdown, you can directly write the formula in Default property of sum text input control or Text property of Label - 

Sum(Gallery6.AllItems, 'Total After STT')

[sarfika]

it's my format wrong?

[NandiniBhagya20]

Your format is correct. I guess the problem is in Contract Utilization Value as it is formatted text.

You can try revising your formula to -

Text(Value(ContractAmount.Text)-Sum(Gallery6.AllItems, 'Total After STT'),"RM##,###,###.00")

[sarfika]

ya, this formular is work. thank you so much for your help