on ‎2020 Jul 22 5:13 PM
What is the detailed syntax to use in a formula for VALUE(). I want to calculate Account1, based on other accounts which have the value Account1 in a specific characteristic. So for example in a Forecast category I am pulling data out of the ACT category, but condensing the accounts. So I have a calculation {AC = A21450 ; FL = F99 ; PE = +0.05} = {AC sum (BS-FC2-19=A21450) ; FL = F99 ; CA = ACT ; DP = +0.05 ; PE = +0.05}, which I then need to repeat for every single account. Is there a way I can use VALUE(AC) in the reference to the characteristic?
Request clarification before answering.
| User | Count |
|---|---|
| 14 | |
| 8 | |
| 7 | |
| 6 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.