This content has been marked as final. Show 8 replies
Use updatable variable to perform the sum of the multiplied values and then perform division as
<?(xdoxslt:get_variable($_XDOCTX, 'num_mul') div sum(current-group()[fld_EARN_CREDIT='Y']/fld_UNT_TAKEN))?>
I still get an error
Can you send me your sample xml and RTF
Have sent back the updated file1 person found this helpful
thanx for the help
Need your help on an issue with XML.
<?CF_INOUT_QUANT_DISP?><?if:position()=last()?><?xdoxslt:set_variable($_XDOCTX, 'inOutQuant', CF_INOUT_QUANT_DISP)?><?end if?>
I have a loop and i need to print the last value amount in the total field for the particular group, that I am doing it using the above command.
Now I need to print the Report total for this column.
Need your inputs on this.
Thanks in advance,
I am looking for a help on doing a sum and dividing by 8. e.g. output
Jan feb Mar Apr ..... Dec Total
1.5 2.5 4.0
I am trying to convert <?value-of:sum(psfn:Val(ssReportedTime) div 8)?> into a valid format
Edited by: user9349634 on 08-Aug-2011 20:13
Can you help me with this requirement of calculating Totals of a calculated column?
I've a spreadsheet with 10 columns.
ship_to, intr_unit_cost, cf_intransit_trans_cost, cf_frt_amount, transfer_price .....etc..
I've already put some tags in 3 of those columns as...
<?xdoxslt:ifelse(SHIP_TO = '347',(TRANSACTION_QUANTITY*TRANSFER_PRICE),CF_INTRANSIT_TRANS_COST)?>
Now I added the totals at the end to cf_intransit_trans_cost, cf_frt_amount columns. By just putting Sum( <respective columns> ) is not giving me the correct result, which means total is not coming up after the above calculation I've included, instead it's coming up with all the amounts. So I thought I should put a similar tags in the summary total fields which includes above calculation and SUM together. May be I should do like xdoxslt:set_variable, get_variable etc.
Anyhelp is very appreciated.