Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
Suppose,when user selects a date in calendar as 1st June 2018(from) till 30th June 2018(to) , here i only want to depict sales for the end date ie 30th june 2018 and all other data against each date should be 0
so in below expression =sign is not functioning
=num(sum({ <Sold_Date = {"< $(To)"} >} Target) ,'#,##0.0')
Try this,
num(sum({ <Sold_Date = { "< $(=Date(To))"} >} Target) ,'#,##0.0')
As always, You are creating multiple threads for single issue. I suggest you to keep one only. Perhaps this?
=num(sum({ <Sold_Date = {">$(=From)< $(=To)"} >} Target) ,'#,##0.0')
Or
=num(sum({ <Sold_Date = {">From< To"} >} Target) ,'#,##0.0')
Or
=num(sum({ <Sold_Date = {">$(From)< $(To)"} >} Target) ,'#,##0.0')
Finally, you must check how variables storing and Field values Sold_Date ??
Please use below expression
=num(sum({ <Sold_Date = {"$(=MonthEnd(Max(DateField)))"} >} Target) ,'#,##0.0')
or
=num(sum({ <Sold_Date = {"$(=MontheEnd($(To)))"} >} Target) ,'#,##0.0')
Regards
Ahmar