Skip to Content
0
Former Member
Nov 21, 2008 at 08:44 PM

Formula based on Display data (summarized data)

23 Views

PrvYrAmt-- PrvYrQty -- AvgPrice---- CurYrQty --CurYrAmt

-


(PrvYrAmt----


(CurYrQty *

-


/ PrvYrQty)----


Prv Yr AvgPrice)

150 -


10 -


$15--


15--


225

100 -


20 -


$5 -


10----


50

Total -


$10 -


25----


250(sum 275)

When I try to create a Formula with CurYrAmt I need to use $275 and not $250.

I tried the SUMCT and SUMCT functions, but it does not use the summarized data $275 as it is a "display data" function. It uses 250 instead.

Does anyone have any ideas to force BEX to use the Summed data 275 in the calculation?

Thanks

Edited by: Rajesh Francis on Nov 21, 2008 9:44 PM

Edited by: Rajesh Francis on Nov 21, 2008 9:45 PM