Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1 (Define Concept) 10 -15 -51 +50 +
Table 2 (Amount)Ncon Tot51 $ 1,000 Minus amount $2,800 + $ 3,300 + $ 600 = $ 6,70051 $ 2,500 Add amount $1,000 + $ 2.500 + $ 3,500 + $ 1,750 + $ 25,000 = $ 33,75050 $ 3,50050 $ 1,750 Real Result -> $ 27,050 not $ 40,45010 $ 2,80010 $ 3,30050 $25,000 15 $ 600
Ncon is a field whose value is defined by a user in table 1 that can be + or - at Therefore Table 2 can't apply a Sum (Tot) as not all values have the samesign remember this definition is found in another table. How can I load my vars in code ?
Thank for your help