Hi Community,
I’m using a Generic Inquiry (GI) and I’ve written a formula to add slight randomization to a calculated amount using the last 3 digits of CustomerID. The formula works fine, except when Quantity = -1 in those cases, I want to skip the random cents and keep the values as-is.
=Switch( [ARTran.Qty] = -1, -1, Round( ([ARTran.Qty] * IIf([ARTran.DrCr] = 'D', -1, 1) * 2) + (((CInt(Right(CStr([ARTran.CustomerID]), 3)) % 99) + 1) / 100.0), 2 ))
Can you any one guide please
+5Your formula appears to be working, but are you hitting the correct fields in your calculation? I’m assuming you want to be calculating off of TranAmt, not Qty.
=Switch([ARTran.Qty] = -1, [ARTran.TranAmt],
Round(([ARTran.TranAmt] * IIf([ARTran.DrCr] = 'D', -1, 1) * 2) + (((CInt(Right(CStr([ARTran.CustomerID]), 3)) % 99) + 1) / 100.0),2)
)Out of curiosity, what’s this being used for?
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.