var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculating a Local Currency Value
I've written an Sql statement to extract the Currency Amount and the currency rate and I want to calculate the Amount in Local Currency.
If the currency amount is in the local currency the Currency rate value returned is 0. I have used a case statement to convert the 0 to 1. (is there
But I now can't calculate my Local amount value because of the way I have converted the currency rate.
Select IH.Amount, 'Currency Factor' = CASE
IH.[Currency Factor] = 0 then 1
else IH.[Currency Factor]
what way should I have written this?
Ya lost me....
How about some sample data and what the expected results should be...DDL would be useful as well....
Geraldine Solved it ..........
WHEN CurFctr = 0 THEN Amount
ELSE CurFctr * Amount
END AS Amount
Thanks Geraldine ... again
Wasn't Geraldine Sanford's wife?