Forum Discussion
snaraya
Helper II
2 years agoNeed help to rectify the formula
Hi All, i am calculating a formula where CurrentAmount / (CurrentAmount + NextAmount) * 1000000 example: 0.1/(0.1+59.9)*1000000 =1666.66 the test column formula is : test = VAR Curre...
- 2 years ago
Issue got resolved, formula i used is correct . Only issue was because the planned column was not rounded off at query editor level causing output to be wrong . Thankyou
snaraya
Helper II
2 years agoIssue got resolved, formula i used is correct . Only issue was because the planned column was not rounded off at query editor level causing output to be wrong . Thankyou