I have a grid that contains the columns: Quantity (numeric), From(date), To(date), Total(custom format)
I would like to insert into the column Total the result of doing: Quantity * datediff(From, To)
The result needs to be formatted in the following format: HHH:MM. Example 120:30.
My questions are:
1) Is there any formula, or group of formulas that I can use to achieve this goal?
2) How can I configure the Grid to recalculate total automatically (on client side) when Quantity is changed?
3) Is there any Manual or Reference guide where I can take a look to the list of functions that I can use inside Formula Field?
myGrid.CalcManager = calcmgr; myGrid.Columns.FromKey("Total").Formula = "????"; // What should I put here?
Thank you
I think this one will handle 1). Except someone else has a better approach.
Regarding 3) I founded already.
string formula;
formula = "concatenate(right(concatenate('000',int(datediff( 'n' , datevalue( '2010-10-12 15:00' ) , datevalue( '2010-10-12 15:26' )) * 3 / 60)),3) ";formula += " , ':', right(concatenate('00',mod(datediff( 'n' , datevalue( '2010-10-12 15:00' ) , datevalue( '2010-10-12 15:26' )) * 3 , 60)),2) )";
Regarding question 2)
Is it possible to use the CalcManager on client side? Or is it 100% Server side?
What I am trying to avoid is to do a Postback. And if the CalcManager works in client side, I will also avoid all the Javascript calculation.