Experssion for multiple price per article

[#1]

Header 1	Header 2	Header 3	Header 4	Header 5
Article	Year-Month	Unit of Price	Number of sale	Total of sale
1234	201401	1000	10
1234	201402	1100	20
1234	201403	1200	30

Dear Friends

I need an experssion for Total of sale (for each Year-Month).

[ashfaq_haseeb]

Hi,

What is the definition of total sale as per you.

Is it like.

Total Sale = Unit of Price * Number of sale or what?

Regards

ASHFAQ

[#3]

Total Sale for each year-month = unit of price * Number of sale ( for 201401 - 201402 - 201403 ,.......)

[ashfaq_haseeb]

Hi,

There is issue with your data model.

If you select some value in your field Year Month, There is no possible association in field Fe which I believe is unit price.

Please fix your data-model

Hope it help

Regards

ASHFAQ

[#5]

Thanks , I fixed data model , but i have duplicate values yet and i don't know how use "SUM IF" for calculate total sale for each year-month.

[ashfaq_haseeb]

Hi,

Are those duplicate values cumming from Database?

If not then need to look at the data model.

Regards

ASHFAQ