show only in straight table

[anitamanders]

I have a straight table with

produktcode, min.stock,  current stock

I have a formula in produktcode

=

if(Dimensionality()=3,
if(sum({<factuurdatum={"<$(VarVandaag))>=$(=VarVorigjaar)"}>}aantgelev)<=0, Red(140), Green(200)))

that turns codes with no sales for a year red and others green.

VarVandaag = today

VarVorigjaar =same day last year

aantgelev =sales in boxes

factuurdatum = sales date

My question: is it possible to show only the codes with no sales (so the red codes with this formula) in the straight table??

[#2]

Remove the last if and under expression select color option, and mark it red

[anitamanders]

I am sorry thomas, i cannot find the color option.

what do you mean?

my current formula is in the background color option in dimensions

I have added my file

[#4]

Ahh i think i misterunderstood your question! sorry..

[Gysbert_Wassenaar · Accepted solution]

See the chart on the right in the attached example. Is that what you need?

[anitamanders]

Hoi Gijsbert,

dat is inderdaad wat ik bedoel, wat heb je precies gedaan?

[anitamanders]

ik zie het al....soms is de oplossing zo simpel...!!