I'm doubt to sum ​​Several fields of the Table

[#1]

Good afternoon, I'm new in the Group, gave some research on the subject before coming to ask this question , but it does not find what I wanted.

I have the following situation

     [SALES 01 - VEJA MULTIUSO 500ML],

     [SALES 02 - VEJA MULTIUSO 750ML],

     [SALES 03 - VEJA PERFUMES 500ML],

     [SALES 04 - VEJA PERFUMES 1L],

     [SALES 05 - VEJA PERFUMES 2L],

     [SALES 06 - VEJA PERFUMES 4L],

     [SALES 07 - VEJA LIMPEZA PESADA 500ML],

     [SALES 08 - VEJA LIMPEZA PESADA 1L],

     [SALES 09 - VEJA LIMPEZA PESADA 2L],

     [SALES 10 - VEJA LIMPEZA PESADA 4L],

     [SALES 11 - VEJA COZINHA DESENGORDURANTE (TRIGGER)],

     [SALES 12 - VEJA COZINHA DESENGORDURANTE (REFIL)],

     [SALES 13 - VEJA COZINHA DESENGORDURANTE (SQUEEZE)],

     [SALES 14 - VEJA COZINHA DESENGORDURANTE (DOYPACK)],

     [SALES 15 - VEJA X-14 TIRA LIMO COM CLORO ATIVO (TRIGGER)],

     [SALES 16 - VEJA X-14 TIRA LIMO COM CLORO ATIVO (REFIL)],

     [SALES 17 - VEJA X-14 TIRA LIMO COM CLORO ATIVO (SQUEEZE)],

     [SALES 18 - VEJA X-14 TIRA LIMO SEM CLORO (TRIGGER)],

     [SALES 19 - VEJA X-14 TIRA LIMO SEM CLORO (REFIL)],

     [SALES 20 - VEJA X-14 TIRA LIMO SEM CLORO (SQUEEZE)],

     [SALES 21 - VEJA VIDREX (TRIGGER)],

     [SALES 22 - VEJA VIDREX (REFIL)],

     [SALES 23 - VEJA VIDREX (SQUEEZE)],

I want to add up all these fields within the code creating total sales .

initially I did

[SALES 01 - VEJA MULTIUSO 500ML]+[SALES 02 - VEJA MULTIUSO 750ML]+[SALES 03 - VEJA PERFUMES 500ML]....(I made for all fields) as [TOTAL SALES].

however not worked.

when I created the chart and I pack the expression brought totally different values.

someone could teach me how to add various fields in charge ?

TKS

[marcus_sommer · Accepted solution]

If any of these fields contained not a valid value (mostly by NULL) the whole expression will be return NULL - therefore you could use rangesum(F1, F2, ...) which returned 0 for any not valid value.

But better would be if you creates a data-stream instead of using these crosstable: The Crosstable Load.

- Marcus

[#3]

tks Marcus