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?
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.
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