Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How can we create a new Field on UI without making any changes on back end script. Month and Value 1 are available. Now user wants to derive Value 2 field as shown below.
Value 2 (Feb) = Jan(Value 1) * Feb(Value 1) = 1.08*1.09 = 1.18
Value 2 (Mar) = Feb(Value 1) * Mar(Value 1) = 1.09*1.04 = 1.13
Value 2 (Apr) = Mar(Value 1) * Apr(Value 1) = 1.04*1.03 = 1.07
Month | Value 1 | Value 2 |
Jan | 1.08 | |
Feb | 1.09 | 1.18 |
Mar | 1.04 | 1.13 |
Apr | 1.03 | 1.07 |
Thanks!
Try this
=Sum(Value1) * Alt(Above(Sum(Value1)), 0)
or
=exp(RangeSum(Above(log(Sum(Value1)), 0, 2)))
Try this
=Sum(Value1) * Alt(Above(Sum(Value1)), 0)
or
=exp(RangeSum(Above(log(Sum(Value1)), 0, 2)))
Thanks Sunny !
=Sum(Value1) * Alt(Above(Sum(Value1)), 0)