Set analysis on an equation

[Anonymous]

Hi All

i am trying to use set analysis of an equation, let me explain i have an equation which as follows

sum ([Total fresh quantity])-(sum((([Total fresh quantity]*[Rejection %])/100)+[Weight of clay]))

and i want to apply set analysis condition

{1<Supplier={'K1'}, Month={'December'}>}

this is how i write it

(sum( {1<Supplier={'K1'}, Month={'December'}>}[Total fresh quantity])-(sum((([Total fresh quantity]*[Rejection %])/100)+[Weight of clay])))

the output isn't correct can anyone advice

[sunny_talwar · Accepted solution]

May be this:

Sum({1<Supplier={'K1'}, Month={'December'}>} [Total fresh quantity]) -

Sum({1<Supplier={'K1'}, Month={'December'}>} (([Total fresh quantity]*[Rejection %])/100)+[Weight of clay])

[Anonymous]

perfect thank you very much