Hi All,
Can anyone please help me solve this small issue. i want to subtract two
numerica fields value in Pentaho Report. But i don't how to do this. I have
this fields for sumDeposits and sumWithdrawals so i want to get the balance
as at present by subtracting sumWithdrawals from sumDeposits but i don't
know how to do that and where exactly to do it( this function and its
syntax). I was thinking of using a message field to write the function in
and also to display result.
And what will be the alias for a database table "other clients details"
with spaces and how to query from a table with spaces in the name and also
column name with spaces?
i was using e.g {select [Phone Number] from [other clients details]} but it
throws errors.
Thanks
Regards
Gloria
------------------------------------------------------------------------------
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users