Thursday, 13 December 2018

BIP: Running Total with uses of round and sdiv(divide function) with xdoxslt


<?xdoxslt:set_variable($_XDOCTX, 'RTotVar', 0)?>
<?xdoxslt:set_variable(
$_XDOCTX,
'RTotVar',
xdoxslt:get_variable($_XDOCTX, 'RTotVar') + ACCTD_AMT)
?>
<?xdoxslt:get_variable($_XDOCTX, 'RTotVar')?>

------------[use in boilerplate text in element]
1. Set a variable and initialize it with 0.
2. Based on IF condition ACCOUNTED_DR is not null, set value of  var from accounted_dr xml element
3. Display value set using get_variable

<?xdoxslt:set_variable($_XDOCTX, 'currentrowdr_share_value', 0)?>
<?if:ACCOUNTED_DR!=''?>
  <?xdoxslt:set_variable($_XDOCTX, 'currentrowdr_share_value', ACCOUNTED_DR)?>
  <?xdoxslt:get_variable($_XDOCTX, 'currentrowdr_share_value')?>
<?end if?>
-----------

------------[use in boilerplate text in element]

Uses of round and sdiv(divide function) with xdoxslt


<?xdoxslt:set_variable($_XDOCTX, 'running_total_share_value', xdoxslt:get_variable($_XDOCTX, 'running_total_share_value')+ xdoxslt:get_variable($_XDOCTX, 'currentrowdr_share_value')-xdoxslt:get_variable($_XDOCTX, 'currentrowcr_share_value'))?>

How to Divide two tag values in XMLP

<?xdoxslt:round(xdoxslt:sdiv(xdoxslt:get_variable($_XDOCTX, 'running_total_share_value'),xdoxslt:get_variable($_XDOCTX, 'running_total_share_qty'), '0'),3)?>

1 comment:

  1. Oracle Apps R12 and Fusion Cloud Self Paced Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com

    ReplyDelete