Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Currently I have requirement of analyzing my data for entered data range like following.
Given date range is ( for ex) <=1/31/2017>=1/1/2017
How I can use above range in set analysis for getting sum of my field for this range?
Thanks,
Pooja
Hello Pooja,
One way i found ignore selections on fields
Try this...
=Sum({<Date={"$(= '>=' & '1/1/2017' & '<='&'1/31/2017')"},Field1=,Field2=,Filed3=>}Values)
Thanks
Mohammed Mustaq
u'd have a date field; the user select 2 dates from the same field; and u want to return the sales btwn the 2 selected dates?
so If ur user select, 15/11/2017 and 11/01/2018 , u want sales btwn those 2 dates right?
if u select these 2 dates:
to retrieve the min date btwn the both? =>15/11/2017 => min(Date)
to retrieve the max date btwn the both? =>11/01/2018 => max(Date)
=> sum({<Year=,Month=,Date={">=$(=min(Date)) <=$(=max(Date))"}>}Sales)
Hello Pooja,
try these to ignore all field Selections.
=Sum({1<Date={"$(= '>=' & '1/1/2017' & '<='&'1/31/2017')"}>}Values)
Thanks
Mohammed Mustaq
Sum({<Date={"$(= '>=' & '1/1/2017' & '<=' & '1/31/2017')"}>}Values)
Here use 1 instead of dollar sign. Then it will not effect