Forum Discussion

Gonqq's avatar
Gonqq
Helper I
4 years ago

Return Distinct values Where condition is met

Hi,
I have a table named "Áreas" where i specify what Cost Centers are inactive. Those Cost Centers shouldn't have values on Accounting. I have another table with a Balance Sheet from Accounting. The objective is to list all Cost Centers that are inactive but still have values atributed to them and present them in a card visual.
Until now i could only come to the sum of the values where Cost Center = inactive and im having trouble isolating the actual Cost Centers and present them on a visual.

 

Formula that I currently have

 

 

Thank you in advance,

cheers

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Do you have an idea of how these cost centers should be shown?  As a table?  As a single string?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Gonqq ,

     

    I'm not quite sure if I understand your needs accurately.

     Samples(without sensitive information)and expected output would help tremendously.

    Please see this post regarding: How to get your question answered quickly

     

    Hope it helps,


    Community Support Team _ Caitlyn Yan


    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.