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])))
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter