Skip to Content
0
Nov 22, 2012 at 11:44 AM

BEx Query Formula

40 Views

Hi Experts,

My requirement is

If exchange rate < 0, (invoice value in local currency) * (counter)

else (invoice value in local currency) / (counter)

I used below formula for field "Invoice value in local currency"

For counter value 1, value is fine.but for other counter values (2 or 3) , result is incorrect (multiplication or division) is not happenning.

Am I not supposed to use same field in formula and store the result in same field (in this case "invoice value in local currency").

If not, please let me know what formula will help me to resolve.

Thanks in advance.

~ Saravanan

Attachments

Capture.PNG (8.5 kB)