formula help

[Former Member]

Hi

I have a field that contains 7 items (1 for each day)

i.e. Mon_item,

      Tues_item

      Wed_item

      Thur_item

      Fri_item

      Sat_item

      Sun_item

each record can have a mix of items (or none)

i.e Record 1 = Sat_item, Sun_item

    Record 2 =  Sun_item

    Record 3 = none

    Record 4 = Mon_item, Wed_item, Sat_item

If the record has an item I would like to display the relevant Day or Days horizontally

i.e. Record 1 = Saturday & Sunday

     Record 2 = Sunday

     Record 3 = [BLANK]

     Record 4 = Monday, Wednesday & Saturday

To make it more difficult I would also like it to display the dates in order based on a date

i.e.

if the date = Saturday then the order of the days should = Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday

if the date = Monday then the order of the days should = Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

if the date = Wednesday then the order of the days should = Wednesday, Thursday, Friday, Saturday, Sunday, Monday, Tuesday

[abhilash_kumar]

Hi Allan,

Would the items be comma separated for each row already?

Would the text contain the Day Name as part of the whole item name, something like:

'Monday_Item_XYZ'

-Abhilash

[abhilash_kumar]

Also, which 'date' do you wish to order the days for each row?

-Abhilash

[Former Member]

The items are individual rows in a string[15] field {RES_ADDON_CODE}

(the data source is an Oracle Function/View that we would prefer not to change)

The names contain an abbreviation for the day at the beginning

SAT PREM DINING

SUN PREM DINING

MON PREM DINING

(Sorry there are also spaces rather than underscores in the names)

The date would be from the DateTime field {SAIL_DATE_FROM}

[abhilash_kumar]

Do you also have some real-time dataset and expected output?

-Abhilash

[Former Member]

Hi

I have sent you an email with a sample report.