Filtering zero values

[#1]

Hi,

In the chart I have following expression:

Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)

My goal is to filter data to show only zero values or values which are <=vInput.

Suppress zero values in Presentation tab is not an option in this case, My opinion is that I can solve this through calculated dimension I Was try with:

=If(Aggr(Rank(Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)<=vInput), Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity))<=vInput, Sifra, Null())

but result is error. Any ideas?

TIA, Igor

[Kushal_Chawda]

try below calculated dimension

aggr(if(Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)<=$(vInput),

Sifra,null()),Sifra)

check suppress when value i NULL option on calculated dimension

Expression will be like below

Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)

[#3]

Thx for your reply, but with yours calculated dimensions all records are shown as null()

[Kushal_Chawda · Accepted solution]

Make sure that vInput has numerical value. it will be helpful if you can share the sample to look at

[#5]

You are correct. Thank you very much. Now I will have peaceful weekend.