SUM multiple conditions

PHOTO EMBED

Sat Aug 17 2024 18:55:42 GMT+0000 (Coordinated Universal Time)

Saved by @Wittinunt

if(or(isnotblank(Filters[Title]), isnotblank(Filters[From...]), isnotblank(Filters[To...])),
sum(select(Expenses[Total Paid], and(
    if(isnotblank(any(Filters[Title])), and([Title] = any(Filters[Title]), [Title]=[_THISROW].[UID]), [Title]=[_THISROW].[UID]),
    if(isnotblank(any(Filters[From...])), [Date] >= any(Filters[From...]), true),
    if(isnotblank(any(Filters[To...])), [Date] <= any(Filters[To...]), true)
))),
sum(select(Expenses[Total Paid], [Title]=[_THISROW].[UID])))
content_copyCOPY

https://www.appsheet.com/template/AppDef?appName