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
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.
After some research, the "Looping in a formula support" has been determined to be a new product idea. I have sent your idea directly to our product management team.
Our product team chooses new ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your idea is chosen for development, you will be notified at that time.
Your reference number for this product idea is PI12110087.
If you would like to follow up on your request at a later point, you may contact Developer Support management via email. Please include the reference number of your product idea in the subject and body of your email message. You can reach Developer Support management through the following email address: dsmanager@infragistics.com
Thank you for your request.
yes, this is a good idea :)
thank you for your help
If you like I could log this as a new product idea for you. Please let me know if you have any other questions regarding this topic.
No, there is no support for looping in a formula.
thank you very much :)
another litle question. if i want to test all the subrow can i do a sort of For Loop?
IF ([../Band 1/Column 0(1)] = 10
IF ([../Band 1/Column 0(2)] = 10
IF ([../Band 1/Column 0(3)] = 10
...