Add a case to IF Query

alec1982 — Thu, 21 Jun 2012 19:37:59 GMT

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,

Re: Add a case to IF Query

CELAMBARASAN — Thu, 21 Jun 2012 20:04:08 GMT

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