Solved

Summing sprcific values

  • 5 June 2023
  • 2 replies
  • 54 views
A
Rank
  • anjana Newly Minted Pigmenteer
  • Newly Minted Pigmenteer
  • 4 replies

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?

icon

Best answer by francois 5 June 2023, 13:48

View original

2 replies

francois
Rank
Userlevel 6
Badge +14

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!

François (Pigment)
A
Rank

That worked ! 

Thank you for the very quick response. 

Reply


Ask your question here!

Terms & ConditionsCookie settings