Multiple Criteria in one formula (similar to a SUMIFS statement)??

[cmccafferty]

Can more than one criteria be applied? So that it works a bit like SUMIFS on Excel.

So for example:

='Single Selling Price : ' & num(max ([Cost PP] where [PriceTypeDescription] = 'Single', and [Ticket Category] = 'First Class', and [Airline] = 'Qantas' ), '£#,##0', '.' , ',' )  so that I only get returned the single price.

Many thanks

Chris

[Gysbert_Wassenaar]

Something like this:

='Single Selling Price : ' & num(max({< [PriceTypeDescription]={'Single'},[Ticket Category] = {'First Class'},[Airline] = {'Qantas'} >}[Cost PP]), '£#,##0', '.' , ',' )

[#3]

Please take attention to Set analysis. The straight answer to your question

=max ({$<[PriceTypeDescription] = {'Single'}, [Ticket Category] = {'First Class'}, [Airline] = {'Qantas'}>} [Cost PP])

[#4]

Please take attention to Set analysis. The straight answer to your question

=max ({$<[PriceTypeDescription] = {'Single'}, [Ticket Category] = {'First Class'}, [Airline] = {'Qantas'}>} [Cost PP])

[sushil353]

Try this:

='Single Selling Price : ' & num(max ({< [PriceTypeDescription] = {'Single'},[Ticket Category] = {'First Class'},[Airline] = {'Qantas'}>} [Cost PP]), '£#,##0', '.' , ',' )

HTH

Sushil

[sushil353]

Try this:

='Single Selling Price : ' & num(max ({< [PriceTypeDescription] = {'Single'},[Ticket Category] = {'First Class'},[Airline] = {'Qantas'}>} [Cost PP]), '£#,##0', '.' , ',' )

HTH

Sushil

[jagan]

Hi,

Try this

= Num(Max ({<[PriceTypeDescription] = {'Single'}, [Ticket Category] = {'First Class'}, [Ticket Category] = {'First Class'},  [Airline] = {'Qantas'} > }[Cost PP]), '£#,##0', '.' , ',' )

Hope this helps you.

Regards,

Jagan.