I forget to info , Table (A) have cal error only when user select TMY or TID or TTH.
When user select TSG the calculation is correct.
kindly use my below QV doc.
Q_PRICE_KINCO_110 ask.qvw 281.5 K
This formula gets you the 661.50:
But I didn't use your field TRANSPORT_SUB cause I am not sure how this factors in. Also its not as perfect as 430/.65. The equation FOB_SGD_SUB*RATE_P/LESS gives you a decimal value, in which you use ceil to make it become 430 in the previous expression. However you didn't do any rounding to it in:
So it is using the decimal value and not the actual value 430 (also you are multiplying TRANSPORT_SUB to it in your equation, which is throwing your number off).
That is why I rounded, then divided:
Also, the value is larger than 661.5, so if you use ceiling, it will round to 662 (which is why i used floor).
I can't be sure what numbers you are actually expecting.
Hope this helps!