Help with a filtered formula

[Marni_Melrose]

Hi there,

I am trying to get the value of a filtered table and I am close but I am stuck. Here is a quick video of what I am trying to achieve.

[Ander]

@Marni_Melrose

In your video it looks like the formula is missing a dot.

FB Daily Campaign Stat.Filter(Date = thisRow.Date AND FB Daily Campaign Stat.Type = Phone Calls) FB Daily Campaign Stat.Amount Spent.Sum()

[Marni_Melrose]

Thanks so much Ander