I have one list called Capital Projects with Orig Budget, Amount Spent, Amount Left. I have another list with invoices with Invoice number and TotalAmount. I wrote a workflow that runs every time an Invoice is entered.
These are the statements: Set Variable: CASAMT2 to Capital Projects #:Amount Spent
Calculate Current Item:TotalAmount plus Variable:CASAMT2(Output to Variable:CalcAmtSpent)
Update item in Capital Projects # (this goes back the Amount Spent Column for the associated record)
It all works well. Only issue is when I Set the Variable CASAMT2, it rounds the Amount Spent number to the nearest dollar. So if the Amount Spent number is 1.56, it rounds it to 2. I would like to know if there is any way around this. I set Amount Spent to be both currency and number and it happens for both cases. Since this is a budget and dealing with currency, I need the 2 digits to be accurate.
Thanks for any help.