Multiply two fields

[alec1982]

Hi,

i have a table that laoding from a resident table.

Residenttable:

ID,

Amount

Factor

From XML Path

CalculationTable:

ID,

Amount * Factor as AmountinUSD

Resident

Residenttable

Not sure why the calculation is not workingeven the Amount field and the factor fields exisit.

Thanks,

Alec,

[CELAMBARASAN]

Have you got any error?

[MayilVahanan]

Hi

     Its work..Try like this,

     Load ID,

     Only(Amount) * Only(Factor) as AmountinUSD

     Resident ResidentTable

     Group by ID;

     Hope it helps

[swuehl]

Can both fields be interpreted as numbers?

What is the input format of your fields Amount and Factor?

What are your default formats for currency / numbers (decimal separator and thousand separator)?

[CELAMBARASAN]

Hi Mayil,

It doesn't calculate(results null) if ID has duplicates.I mean if ID has multiple amounts and Factor

[alec1982]

hi,

They are both Nrs.

Thanks,

[MayilVahanan · Accepted solution]

Hi

     Thanks cimbu for your tips..I thought its distinct ID..

     Sum(Amount) * Sum(Factor) as AmountinUsd..

or

     Amount * Factor

     If both are number format.. Suppose, Anyone contain non - numberic value means, it doesn't satisfy..Please mack sure the format..

Hope it helps

[alec1982]

The way I had was working but the factor field has values of 1 in most cases.

Thanks for all your help.

Alec,