I'm trying to undertake what I'd assume to be a simple calculation, using a Calculation app, which references a couple of other fields. But for some reason, it won't subtract.
Heres what I'm attempting to do - possibly it'll make more sense that trying to explain verbally:
"$ " + (@Field1 * @Percentage) - (@Field2 + @Field3)
I'd expect to obtain a percentage of the "Field1" number from the results from the first brackets, and then I'd add Field2 & Field3 together, and subtract the result of that calculation from the first bracketed result to obtain my end result.
I'm using the "$" symbol at the start, as I'll need to use the figure in this field elsewhere, and it needs to have a currency symbol at the front of the resulting number.
Any help greatly appreciated.
Please sign in to leave a comment.