How to get the total in the expression ?

[suvechha_b]

Hi All ,

Please see the first column "Export Only - Net Stock Available" is not having sum in the above.

But when I am select distributor as 'ASPEN' the total sum is showing.

My Requirement is that , the model should show the total even if I don't select the distributor in filter.

I have attached the sample model.

Thanks,

[tresesco · Accepted solution]

Just remove the IF conditional part from your expression.

=if(distributor='ASPEN',sum({<[plant_code]={'TEX','IFG','STX'}>}$(vMeasure)),0)