Expression, show data acording to date.

[goro2010]

Good Day Everyone,

I am trying to do an expression that only rely on your date selection.

Currently my sum expression takes all the volumes of "qty" and give me the sum, regardless if you have selected a date or not.

I need the sum to be zero if no date have been selected, and only work out the sum of the date and / or date range that I have selected.

Is this possible?

Thank You!

[tresesco · Accepted solution]

May be like:

If( GetSelectedCount(DateField), <Your expression>,0)

[goro2010]

Brilliant, thank you for the quick response. I get now that the values is showing all zero's, but once I select the date now, I get all values -1.

Here is my expression: =If(GetSelectedCount(OrderDate), Sum(qty),0 )

Thank You!

[awhitfield]

Hi Jan,

I Guess one way is to add a calculation condition, so the chart isn't calculated at all until you select a date:

Then add a Custom error Message e.g. please select a date....

Andy

[Kushal_Chawda]

try this expression

=sum(Sales) * if(GetSelectedCount(Date)>0,1,0)

Note: Also, go to presentation tab of chart, and uncheck Suppress zero values , to show 0 values on chart

[goro2010]

Hello, I have found that there was an issue with my expression, it is working brilliant now! - Thank You

[goro2010]

Also working - Thank You