I need to fix IF. Fixed Report

[Ribeiro]

I need product code 23927 to appear in the above chart.

I need to correct this set analysis. "Quantidade_IntesCOM)<>0"

if(sum({$<Ano ={$(=Year(today()))}, Mes={$(=Month(today()))},Dia={$(=Day(today()))},[CodigoFilial]={'1'},[Linha_Excluida]={'0'}>}Quantidade_IntesCOM)<>0,

sum({$<[Linha_Excluida]={'0'},[CodigoFilial]={'1'}>}Quantidade_IntesOTE))

The result I need is this. But this one with no fixed filter

[ali_hijazi]

check attached

is this what you want? !

if(sum(aggr(sum({$<Ano ={$(=Year(today()))}, Mes={$(=Month(today()))},[CodigoFilial]={'1'},[Linha_Excluida]={'0'}>}Quantidade_IntesCOM),CodigoProduto))<>0,

sum({$<[Linha_Excluida]={'0'},[CodigoFilial]={'1'}>}Quantidade_IntesOTE))

I removed the Dia={Day(Today())} cause your data shows fdata for 21 instead of 22

[Ribeiro]

Personal Edition,

You could tell how you solved it ... qvw no

[ali_hijazi · Accepted solution]

I've written the expression above

you need to check if the sum is zero by product so I made the check to be sum(aggr(sum.....,CodigoProduto))