Calculated Column values

Mon, 08/29/2011 - 01:13
Presto Version: Presto 3.0
rajarajan
User offline. Last seen 26 weeks 5 days ago. Offline
Joined: 08/05/2011
Points: 21

Hi,

     I have a column with numeric data in it. How to make arithmetic calculations over that data and display it. For example:If the data is 105.65..The calculation to be done is 105.65*100(Column values * 100)...Finally It should be displayed as 10565..

can anyone help??

0
Your rating: None
Mon, 08/29/2011 - 12:58
Copy comment link
raj
raj's picture
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 09/22/2008
Points: 4

 hi rajarajan,

Do u want to do this in Mashups ? If so, u can do the following :

 

       <constructor outputvariable="mydoc">

            <items>

                <data>100.11</data>

                <data>200.12</data>

                <data>2222.12</data>

            </items>

        </constructor>

                

        <assign fromexpr="$mydoc/items/data/(number()*100)" toexpr="$mydoc/items/data" mode="replace" />

modified $mydoc would contain:

 

<items>

   <data>10011</data>

   <data>20012</data>

   <data>222212</data>

</items>

 

 

 

 

raj.  chief masher @ jackbe