Add a case to IF Query

[alec1982]

Hi

I am using the following Query

='' & Num(

    Sum(sum(Sales)

       )

      / if((GetFieldSelections(_BTActiveCurrency) = '$USD'), 1, $(varBTExecSummaryUsdPerGbp))

      /if(GetFieldSelections(_BTUnitOfMeasure) <> 'SQF', 0.09290304, 1)

, if((GetFieldSelections(_BtMrkPrfShowMarketRentSavingsPerUom) = 1), '#,##0.##', '#,##0'))

It works fine..

Now I need to add another case:

if((GetFieldSelections(_BtMrkPrfShowMarketRentSavingsPerUom) = 1) Use Sum[FieldAA] as Expresion

Any Ideas..

Thxs,

[CELAMBARASAN]

Hi,

='' & if((GetFieldSelections(_BtMrkPrfShowMarketRentSavingsPerUom) = 1),Num(Sum([FieldAA]),'#,##0.##'),

Num(

    (sum(Sales)

      / if((GetFieldSelections(_BTActiveCurrency) = '$USD'), 1, $(varBTExecSummaryUsdPerGbp))

      /if(GetFieldSelections(_BTUnitOfMeasure) <> 'SQF', 0.09290304, 1))

, '#,##0'))

Celambarasan