Skip to Content
0
Jul 22, 2020 at 04:13 PM

Using VALUE() in a calculation

38 Views

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?