Hi
I want to calculate value of one field depending on the value of other field.
For example :
There are two fields viz. Price and Currency Type
Now I want to calculate price depending on Currency Type. For example suppose Currency Type is D then it should take the exchange price of US$ and multiply the value from price field with that exchange value.
Suppose : Value in the price field is : 100
Currency Type is : D
Exchange price is : 46
Then the resultant value in output report should be 4,600/-
Please help me out.
Regards
Rakesh Gupta
