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