Dropdown menu won't sum #s in table

[Breezy]

Hello,

I have a dropdown menu titled 'Location'. When I select Guam numbers appear in my table. When I select Argentina the appropriate numbers appear in the table. When I select them BOTH at the same time from the dropdown menu my table is empty! Why aren't my numbers adding up?

[Breezy]

Hi,

I see. Yes, N/A is definitely a non-numeric value. I am going to add a months column here so it is more clear. I was indeed summing the amounts per month (for titles Expected and Actual appearing in app). I see now there is no formula (to keep N/A) if I want to use the sum function. I do appreciate you clarifying that for me. Learned more about the sum function today. Thanks again for your time!

[Breezy]

I can probably go ahead and accept this as the solution now.

[Or]

There are some tricks you could try if this is important enough, maybe something along the lines of:

If(Only(frogprice) = 'N/A','N/A',Sum(frogprice))

Or perhaps

Coalesce(Sum(frogprice) * if(NOT Only(frogprice)='N/A',1),'N/A')

[Breezy]

I'll give it a try. Thanks!