Get Field Selection - less than

[#1]

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))

[rwunderlich]

Sum({$<calendar_date={'<=$(=only(calendar_date))'}>} on_hand_qty))

-Rob

[jonathandienst]

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

[sivasiri99]

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