Skip to main content

Hello

I am trying to pull data on one dashboard from another , where I am trying to sum up 2 specific accounts. This is the formula I am using : 

'Data - Monthly - Final''filter: 'CoA & Function'.CoA = CoA."30012" AND 'CoA & Function'.CoA = CoA."30011"]

 

What is wrong here? The amount come up blank. When I remove the text post “30012” I get the numbers for 30012. Is AND not something I should use here?

Hi!

Your condition can not be respected - no Account can be both 30012 and 30011 at the same time. 

Have you tried switching your condition to OR? 

Hope this helps!

That worked ! 

Thank you for the very quick response. 

Reply


Ask your question here!

Terms & ConditionsCookie settings