Skip to main content
Solved

Summing sprcific values

  • June 5, 2023
  • 2 replies
  • 207 views
A
Wallflower

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?

Best answer by francois

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!

    Katrina

    2 replies

    francois
    Employee
    Forum|alt.badge.img+13
    • francoisEmployee
    • Employee
    • Answer
    • June 5, 2023

    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)
    Katrina
    A
    Mat
    A
    Wallflower
    • anjanaWallflower
    • Author
    • Wallflower
    • June 5, 2023

    That worked ! 

    Thank you for the very quick response. 

    KarlW
    Mat

    Ask your question here!

    Terms & ConditionsCookie settingsAccessibility statement