Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following set analysis, which is showing me inventory for the date i have selected.
How can i modify it to show me the inventory for all dates less than or equal to my selection?
Sum({$<calendar_date={'$(=GetFieldSelections(calendar_date))'}>} on_hand_qty))
Sum({$<calendar_date={'<=$(=only(calendar_date))'}>} on_hand_qty))
-Rob
Hi
Try this:
Sum({$<calendar_date={"<=$(=GetFieldSelections(calendar_date))"}>} on_hand_qty)
(note the double quotes) But this will fail if you have more than one calendar date selected. You can also try:
Sum({$<calendar_date={"<=$(=Date(Max(calendar_date)))"}>} on_hand_qty)
(assuming calendar_date is in the default date format for you model - otherwise modify the Date() statement)
Hope that helps
Jonathan
Hi Jonathan
i would like to have only current selected date and (+5 day and +10 day and +15 day)
example if i had selected :30 dec 2016 in list box in chart i should have 3 Jan 2017 and 8 Jan 2017 and 13 Jan 2017 .
Could you help me out.
sivaram