sum(field) not working when using nulls

[felcar2013]

hi

i have two end tables shown in the attached Image. I want to delete the ""Zeros" that appear in the first table. For this i used
the Expression (customer is the fact)

if(len(trim(customer))>0,sum(customer),'')

this solved my Problem, but then i cannot sum the subtotals for "multichannel" Dimension value,  as you can see in the second Chart ("# of Club customers")

there are "nulls" in the values of "customer" and i am aggregating by country

How can i get the total there?

thanks

[Jason_Michaelides · Accepted solution]

That's because you are replacing numbers with text so you can no longer sum them together. If you really don't want to view them then consider cheating by using conditional colouring to make them white...

Hope this helps,

Jason

[felcar2013]

thanks

i set a condition for "font" Color and solved the issue

fleipe

[Jason_Michaelides]

Glad it worked. Please mark a correct answer to close the thread.

Jason