0 Replies Latest reply: Sep 21, 2011 10:52 AM by Christophe Decluseau RSS

    Problem of matching

      Hi all !

       

      For an application, I need to reduce data but keeping the total result. Example :

      Tab_Data :

       

      RegionNetworkIdDateSale
      11jun.1115
      11jul.1164
      12jun.1141
      12jul.1112
      21jun.1146
      21jul.1123
      22jun.1121
      22jul.1141

       

      If I reduce on Region = 1, the user can see his sale (15, 64, 41, 12) and the total country (263). He can't see details for Region 2.

       

      So I create a new data island table :

      Tab_Data_total :

       

      Total_NetworkIdTotal_DateTotal_Sale
      1jun.1161
      1jul.1187
      2jun.1162
      2jul.1153

       

      I use dimensionality in my result table to display the details for user in NetworkId1 and the total in total line.

       

      My problem is in my total expression. I wrote :

       

      sum(if(Total_NetworkId=NetworkId AND Total_Date=Date, Total_Sale))

       

      If Date correctly matching (for 1 or more selections) it doesn't work for NetworkId. I don't know why ! I use this type of expression many time to use data island table.

       

      After a litle control with isnum(), i see that my field NetworkdId is a numerical field. But my new field Total_NetworkId not ! Do you think that's the explanation of my problem ?

       

      I don't understand why QV transform this numerical field into something else in the new table. I try to force a numerical value for Total_NetworkId by using num(), but it doesn't work !

       

      Thank you for your attention and many many thanks for help !!!