How to calculate a sum of total in a table if we mention a character in front of the value

[#1]

Hi anyone pls help me with this...

I have an Table with sum of total amounts mentioning (Rs.) infront of the value how to get a total value of that row..?

Eg :

I want a total for this table at bottom...

Thanks in Advance

[ariel_klien]

Hi

Try sum(num(TextBetween(Amount,'Rs.','')))

BR

Ariel

[luciancotea]

or

sum(num(replace(Amount,'Rs.','')))

[#4]

If you want the above rows to contain the 'Rs.' you should use:

if(rowno()=0,sum(num(replace(Amount,'Rs.',''))),Amount)

and set the total modus to 'expression total'.