i'm using 2 types of database which are SQL and excel. in CR i created group based on products model (formula). In excel the database shows the sales qty based on model and customers. therefore, in CR i would like to export data of sales qty which based on model and customers. and then,  i created a formula as below but it only workout for one model.

 

formula:

IF GroupName ({@Model}) = {Sheet1_.MODEL} and {tdsls401.ofbp}= {Sheet1_.customer}  then

{Sheet1_.sales qty mei}

else 0

 

in Excel, database is as below

customer     model      sales qty mei

a                  VA            20

a                  VB              1

b                  TC             50

 

the result that i got is only " a         VA     20" others didnt get.

 

hope anybody can help me..