Expression

[#1]

Hi all,

I got this table showing me the Km's per truck per week. Now I would like it to show me only the trucks that haven't had any kilometers per week. If I now would say pick week 1 it will show me the trucks that have had kilometers that week. And when I select 10 weeks it will also show me the trucks in week 1 that had 0 kilometers.

expression:
sum(Distance)

kind regards,

Vincent

[alexandros17]

change your expression in:

If(sum(Distance)=0, 'Zero KM', 0)

with this expression when you have zero you set Zero Km, all others will have 0 and if you have kept default settings the checkbox exclude zero values will be cheched

hope it helps

[#3]

Hi alessandro,

This indeed gives me the trucks that had 0km's but it isnt really a pretty lay-out. And is it possible to count the number of zero km's trucks?

[santharubban]

Try this

=sum({<Distance = {0}>}Distance) in expression

or

=aggr(sum({<Distance = {0}>}Distance),fleetnumber,year) in diminsion

[#5]

Hi Vincent

as far as i can see in your exl sheet some trucks have 0 in week 1

so to see only these trucks but along all weeks you can play with background colors

if (sum(distance)>0, white())

so you'll get white/white color nothing to see, but 0

best regards

chris

[#6]

Hi try this...i hope this will help u...

[#7]

[alexandros17]

could you send me your document?

[#9]

if I upload it here it would be without data i guess?

[alexandros17]

Use scramble instruction ...