Hi
I have a straight table where i need to find an exception report with multiple dimensions. Flags are being provided to me for exception report which i have used in expression.
i have got a row count of 2932 in the straight table, i need to get this row count in a text box.
if((isMissingCRMSoldTo='Y' or isMissingCRMShipTo='Y') and ignorecustomer='N' and isDuplicate='N' and isInValidDistributorCode='N' ,1,0)
I am using this above expression to do my exception report.
for getting the count of all the rows i am using
=sum(Aggr(if((isMissingCRMSoldTo='Y' or isMissingCRMShipTo='Y') and ignorecustomer='N' and isDuplicate='N' and isInValidDistributorCode='N' ,1,0),File_DistributorCode,inmarketsoldtocoderefrence,File_SoldToName,inmarketshiptocoderefrence,File_ShipToName,File_PostCode,File_Suburb,File_Region,Country,SoldToName,ShipToName,C01SOLDTO,C01SHIPTO,isMissingCRMSoldTo,isMissingCRMShipTo))
here in aggr() i am using the dimensions and sum() for getting the count.
but the row count is coming different, getting the difference of 75
can anyone help?
