Use Set Analysis

[#1]

hi,

How transpormar following expression to set analysis ? For the exposed form generates the incorrect value, why not obey selection of products.

sum (if (ProductName = 'CAPPUCPRONTO'), Vol_Umb/12, Vol_Kg)

Thank you!

[shree909]

Hi use this

=sum ({<ProductName ={'CAPPUCPRONTO'}>} Vol_Umb/12, Vol_Kg)

is 

Vol_Umb/12, Vol_Kg is one filed or 2 fields...  for one field it works fine

if it is 2 fields use the aggregation..

Aggr(sum ({<ProductName ={'CAPPUCPRONTO'}>} Vol_Umb/12), Vol_Kg)

if not clear please post a sample of file with fields names..

[#3]

hi,

Are two distinct fields.

The expression did not show any results.

I managed to solve the following expression, not very elegant, but gave the correct result.

=sum({$<Nome_Familia1 = {"CAPPUCPRONTO"}>} Vol_Liq_Umb/12 ) + sum({$<Nome_Familia1 -={"CAPPUCPRONTO"}>} Vol_Liq_Kg)