I Obtain a #value ! on cell after applying this formula : if( [../cout_tranche/num_tranche]=10 , round( ( [COUT_TRAC_MOY] / [TARIF_TRANCHE] )*100 ,2)).
../cout_tranche/num_tranche = band 2 of my grid
If want to show a value of one row of childBand in Parent band ( band 0)
is the right syntax?
To refer to a specific cell, you use an index after the column name.
So if you are writing a formula for the val3 column and you want to get the value of subrow2Val1, you would do something like this:
"[../Band 1/Column 0(1)]"
Column 0 in this case is the first column in Band 1. The "(1)" refers to row number 1 - the second row in the list.
So your whole formula might look something like this:
"IF ([../Band 1/Column 0(1)] = 10
, [../Band 1/Column 2(1)]
, 0)";
If the first cell in the second child row is 10, then use the value from the third cell in the second child row; otherwise, use 0.
thanks for your anwser,
but I don't want the sum i need to choose a particular cell in child row and copy automaticly this cell value on parent row.
val1 val2 val3
subRow1Val1 subRow1Val2 subRow1Val3
subRow2Val1 subRow2Val2 subRow2Val3
on this sample i want to replace val3 by "subRow2val3" if subRow2Val1=10, With formula to export the cell formula on excel
ps sorry for my english
Hello wassistef,
You could achieve this with the following code sample:
ultraGridColumn1.Formula = "sum( [../band 1/column 0] )";
Please feel free to let me know if I misunderstood you or if you have any other questions.