Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to calculate for the DAY sales.
let suppose today is 10/10/2014
I want to today sales only
what would be expression please help. I don't want to do it thru selection parameter.
my sales expression =sum(sales).
=Sum({<Date_field={'$(=Today())'}>}Sales)
Hi
Try like,
sum({<yourDate={"$(=Date(max(dateField),'DD/MM/YYYY')"}>}sales).
Regards