urgent : how to write a condition in rtf

Rashmi

Summary

urgent : how to write a condition in rtf

Content

in bi publisher template, if there are multiple same values in a field( for eg: tax name for 3 items are same and i want them to be displayed in one row with their respective tax_amount added in the same row), how will i do it?

 

like for 3 items, two tax_names are assigned cgst9% whose tax_amount is 90 and sgst9%, whose tax_amount is 10 .now i dont want them to be displayed individually in many rows,, but just in two rows, with their tax_amounts summed as 270 in one row and 30 in second row.

 

cgst9%    270

sgst9%    30

 

also if these tax_names are different, then they should not get added

 

cgst2%   50

sgst2%   60

cgst3%   40

sgst3%   20

Brajesh Shukla-95078

1. if you have two different tags in XML like CGST and SGST you can directly use <?sum(cgst)?> or <?sum(sgst)?> to get respective amount

2. if you have single TAX_AMOUNT tag in xml and along with that you have one more tag TAX_CODE to identify weather its SGST or CGST you can use below to get sum

to get sum of CGST : <?sum(TAX_AMOUNT[../TAX_CODE='CGST'])?>

to get sum of SGST : <?sum(TAX_AMOUNT[../TAX_CODE='SGST'])?>

Dir_Pal

<?xdofx:if  statement= XXX then 'mmm'

else if statement= = 'YYY'  then 'dddd'

end if?>

Rashmi

i wanted it with the help of if else condition. if the tax names are same they must occur once and their amount must get added.

and if the tax_names are not same they should repeat with their values in front

Brajesh Shukla-95078

Its same as second case correct  (<?sum(TAX_AMOUNT[../TAX_CODE='SGST'])?> ) ?

Only put this sum inside if example

<?if:TAX_CODE='SGST'?>   <?TAX_CODE?>  : <?sum(TAX_AMOUNT[../TAX_CODE='SGST'])?>  <?end if?>

This will print SGST sum only if SGST tax is there.

If still it doesnot fulfill you requirement please provide snapshot of your XML data it will be easy to guide you