Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
In the below chart I want when user selects date range From calender then sales for entire date range should be depicted in chart
Here In MRP daily Target sale is coming out to be 0
Following expression is used
=num(sum({<Sold_Date={">=$(From)<=$(To)"} >}DISTINCT Budget))
What all changes are required in expression
try removing the $ sign from 'From' and 'To' variables.
Test the value in a text box to confirm that the values in the variables match the Sold_Date format.
STILL SAME PROBLEM EXISTS
Hi,
There is two special operators called precedes and follows that could be used in your case I think:
Try this ::
=num(sum({<Sold_Date={"'$(From)' precedes '$(To)'"} >}DISTINCT Budget))
Hi
Its not giving result
From this expression
=num(sum({< Sold_Date = {">=$(=From)<=$(=To)"} >}DISTINCT Budget),'#,##0.0')
I am getting values but all are same under MRP daily target heading. so here values should be distinct so what all changes are required
Sample QVW please.
Best way to get the better and quick solution is providing sample data and expected result.Thank you.