Totals on a calculated field in RTF template showing zero...
I am new to BIP and trying to get totals on a calculated column. The calculation shows correct data but the sum of it is not getting calculated.
Eg.
XML tags : <Unit> and <Price>
O/p shows
<Unit> <Price> (<Qty> * <Price> )
10 2 20
20 2 40
Now I need the total on the <Qty> * <Price> which is not part of the xml output. It's showing zero...
What am I doing wrong ? Or How can I get it to total correctly.