Hello everyone !
I want to visualize a bar chart for different aircraft configurations and calculate the potential value for them : [AC Type] &'|'& [AC Subtype] &'|'& [AC Engine Type] &'|'& Conf : i have a case wher i should choose two conf like this : 'A320|CEO|DAR|V2500|ACMS|DAR' so i think to add conf two times : [AC Type] &'|'& [AC Subtype] &'|'& [AC Engine Type] &'|'& Conf&'|'& Conf but it doesn't work
this is the formula :
=if (match( [AC Type] &'|'& [AC Subtype] &'|'& [AC Engine Type] &'|'& Conf&'|'& Conf ,' A320|CEO|CFM56|ADC|','A320|CEO|CFM56|ACMS|DAR','A320|NEO|LEAP-1A|ADC|','A320|NEO|LEAP-1A|ACMS|DAR',
'A320|CEO|V2500|ADC|','A320|CEO|DAR|V2500|ACMS|DAR'),
[AC Type] &'|'& [AC Subtype] &'|'& Conf &'|'& [AC Engine Type] &'|'& Conf )
i hope it was clear for you
thank you
