flagurugrl
Technical User
Hi All,
I am a newbie using crystal so please don't laugh if this seems simple.... I want to take 1value - 2value * 3value and place the result in a field called open value... I used the "formula Workshop" and when I check the formula its ok but when I refresh the report data it returns a wrong answer.....
All three values are numbers... the 1st 2 are regular numbers and the 3rd is currency... please tell me what I am missing
formula = {OpenOrders.QuantityOrdered_3} - {QuantityShipped_3} * {ExtensionAmt_3}
THANK YOU IN ADVANCE!
I am a newbie using crystal so please don't laugh if this seems simple.... I want to take 1value - 2value * 3value and place the result in a field called open value... I used the "formula Workshop" and when I check the formula its ok but when I refresh the report data it returns a wrong answer.....
All three values are numbers... the 1st 2 are regular numbers and the 3rd is currency... please tell me what I am missing
formula = {OpenOrders.QuantityOrdered_3} - {QuantityShipped_3} * {ExtensionAmt_3}
THANK YOU IN ADVANCE!