Skip to Content
0
Former Member
Jul 22, 2013 at 11:32 AM

Alternative function for ForEach()?

66 Views

Hi BOE experts,

We have a report that has timestamp field in format: YYYYMMDDHHMMSS-0Plant

Eg : for plant 1AHM, 7/22/2013 11:10:59 AM --> timestamp = 20130722111059-1AHM

The report is run for single day and mutliple plants.

Some plants can have single timestamp and few can have more than 1.

Customer wants to display a warning message if we have multiple timestamp per plant.

Suppose timestamp = 20130722111059-1AHM and 20130722111158-1AHM, I need to show a message

I used formula: If (Count(timestamp) > 1 foreach(plant) ) Then "warning :multiple ITU for plant [plant]"

I am displaying it in a single cell on top of report. it is giving me #multivalue ERROR.

Am I making any mistake in the formula or is there another way to solution this?

I tried other way (substr()timestamp- take only time (HHMMSS) if its distinct per plant then show message.That dint work as well

Please help

Thank you.