How to input "OR" set expression in report editor

[wendytham]

Hi All,

I would like to create a title in my report like "Sales start=07/2018 / Factory = ABC".

Some of the model in my data has sales start date, and some don't have.

In order to show the sales start date in the report, I used the below expression (highlighted in red) in my report editor.

However, the below expression only apply for those models that do not have sales start date.

If the model has sales start date in the raw data, it will show empty field. (If i changed the expression to Date(SalesstartDate, 'YYYY/MM'), the date will be shown in the report.)

How to use "OR" expression to enable both date show in the report?

='Sales start= ' Date(firstsortedvalue ( {<[Accumulated Sales Qty]={'>=1'}>}  Monthname, [Accumulated Sales Qty]),'YYYY/MM') & '  /  Factory= '& if(Isnull(Factory) , 'Unknown' , Factory)

[Anil_Babu_Samineni]

Perhaps this?

='Sales start= ' Alt(Date(firstsortedvalue ( {<[Accumulated Sales Qty]={'>=1'}>}  Monthname, [Accumulated Sales Qty]),'YYYY/MM'),firstsortedvalue ( {<[Accumulated Sales Qty]={'>=1'}>}  Monthname, [Accumulated Sales Qty])) & '  /  Factory= '& if(Isnull(Factory) , 'Unknown' , Factory)

[wendytham]

Hi Anil,

It only works for those models that do not have SalesstartDate.

Thank you.

[sunny_talwar · Accepted solution]

May be this

='Sales start= ' &

Alt(Date(SalesstartDate, 'YYYY/MM'),

Date(FirstSortedValue({<[Accumulated Sales Qty] = {'>=1'}>}  Monthname, [Accumulated Sales Qty]), 'YYYY/MM'))

& '  /  Factory= ' & If(IsNull(Factory) , 'Unknown' , Factory)

[wendytham]

This doesn't work as well.

[sunny_talwar]

Would you be able to share a sample to show the issue?