Hi,
I have a grid with the following columns and need formula and calcution, but I don't really know how to work it out with WinCalcManager.
Here is the scenario
My grid have 5 columns, Drug Name, Country, Brand, Unit Sale and Calculation
The Calculation column is base on all the other 4 columns. If the Brand cell is empty, the cell for Calculation column will be empty.
If not, Calculation cell will be calculation as follow:
Unit Sale cell / Sum of all rows of Unit Sale cells that have the same Drug Name, Country, Brand
for example:
Drug Name Country Brand UnitSale Calculation
Drug1 US brand 10 10 / (10 + 20)
Drug1 US brand 20 20 / (10 + 20)
Drug1 US 10
Drug1 Japan brand 10 10 / (10)
Drug2 US Generic 10 10 / (10 + 15)
Drug2 US Genric 15 15 /( 15)
Drug2 Japan Generic 30 30 / (30)
Drug2 Japan 50
There's no way for the CalcEngine to sum up only certain rows with certain values - unless you use OutlookGroupBy functionality in the grid and group by the Brand field and then add a summary. You could then use that summary in your calculations. You could use the 'IF' function to handle when the Brand is blank.