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

    Return values "where" condition is true

    Chris McCafferty

      Hi,

       

      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

      Chris