7 Replies Latest reply: Apr 24, 2013 11:24 AM by Yusuf Ali RSS

    Return values "where" condition is true

    Chris McCafferty



      I am trying to get Single Prices and Twin Prices into seperate boxes. Very simple. Just a box that shows the amount.

      So, at the minute I have these:


      ='Single Selling Price : ' & num(max ([Cost PP]), '£#,##0', '.' , ',' )







      I have another table [PriceTypeDescription] that shows me the price for a single and the price for a twin. I was wondering how I can do a statement in my above formula that sort of says:

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



      Many thanks in advance