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