none
Sum value by column filter RRS feed

  • Question

  • Basically want to do a sum based upon a filter. I created a column where 1 represents PO# formats I want to filter by

    =Sum(Exp[Release_Note_Qty],Exp[Pipe_POS_1]=1) but it is not working

    I am trying to determine what I am doing wrong here, any ideas?

    Thanks for your help

    Kevin

    Monday, May 14, 2012 3:18 AM

Answers

  • Try using the below:

    =Calculate(Sum(Exp[Release_Note_Qty]),Exp[Pipe_POS_1]=1)

    By embedding the code in calculate function you will be able to get the desired result. 



    Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

    • Proposed as answer by san463 Tuesday, May 15, 2012 4:28 PM
    • Marked as answer by Elvis LongModerator Monday, May 28, 2012 1:55 AM
    Tuesday, May 15, 2012 4:28 PM

All replies

  • Try using the below:

    =Calculate(Sum(Exp[Release_Note_Qty]),Exp[Pipe_POS_1]=1)

    By embedding the code in calculate function you will be able to get the desired result. 



    Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

    • Proposed as answer by san463 Tuesday, May 15, 2012 4:28 PM
    • Marked as answer by Elvis LongModerator Monday, May 28, 2012 1:55 AM
    Tuesday, May 15, 2012 4:28 PM
  • Worked Thank you
    Monday, May 28, 2012 2:24 AM