8 Replies Latest reply: Jan 2, 2017 6:49 AM by EUGENIO FERNANDEZ ORTIZ RSS

    Calculation filtering some  values of a dimension

    EUGENIO FERNANDEZ ORTIZ

      Hello:

      I have a dimension called "Centro" (Values: ND1, ND2, ND3, ND4, NR1, NR2, NR3, NR4, NF1, NF).

      I want to calculate the measure "%Scrap" as "Sum(CHTQuantity)/Sum(PQuantity)*100" but only with some values from the dimensión "Centro" (NR1,NR2,NR3, NR4, NF1 and NF). How can define the formula?

      Thank you in advance