Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
Have you got any error?
Hi
Its work..Try like this,
Load ID,
Only(Amount) * Only(Factor) as AmountinUSD
Resident ResidentTable
Group by ID;
Hope it helps
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)?
Hi Mayil,
It doesn't calculate(results null) if ID has duplicates.I mean if ID has multiple amounts and Factor
hi,
They are both Nrs.
Thanks,
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
The way I had was working but the factor field has values of 1 in most cases.
Thanks for all your help.
Alec,