Search code examples
pentahodata-integrationspoon

Using the (A*B) function in calculator- Pentaho spoon-

I'm trying since yesterday to use the function (A * B), very simple like operation, but it does not work. Any help! thank you.

https://drive.google.com/folderview?id=0B3XPAOxNJYxMfno0V0I3N21wblBhR1lyekhpNWlzb21XN2pHckJYRkdpSDNMX1NGT1hzQVk&usp=sharing

Solution

  • Add the following two additional steps String operations and Select Values to the same ktr. enter image description here

    In String Operations step do the following configurations. enter image description here

    And in Select values step use the below mentioned configurations in Meta-data tab. enter image description here

    And Finally in Calculator step you can use the value type as BigNumber and a conversion mask #.# for your new field Total.

    P.S There was a leading space in fields Prix and Ventes that had to remove using String operations step. That's why it failed in multiplication.