urgent : how to write a condition in rtf

Question

Summary

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 · Answer

Its same as second case correct ( ) ? Only put this sum inside if example : 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

Brajesh Shukla-95078 · Answer

1. if you have two different tags in XML like CGST and SGST you can directly use or 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 : to get sum of SGST :

Dir_Pal · Answer

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

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

end if?>