BEx Query Designer - working on fields calculations
I Developed Query which will give me output for Amount of Consumption of Chemicals during selected Period and Profir Center.
I Display Amount field using formula
also i calculate amount of one material (CANE) using formula, now i want to calculate cane / amount and display in third colum for Example :
- CANE --
| Cane / Amount
2000001 RANOCIDE M |----
| 587,984.30 INR
2000002 RANOCIDE SR |----
| 473,880.80 INR
2000003 SANTROSE |--
| 270,818.20 INR
CANE CANE | 2,961,039,200.47 INR | X |
now in Cane / Amount formula field i am not getting any value , Please can some one Provide me solution for it...
I dont want to display material Cane in output
my output should look as follow:
Material | Cane / Amount | Amount
2000001 RANOCIDE M | 5,035.92 | 587,984.30 INR
2000002 RANOCIDE SR | 6,248.49 | 473,880.80 INR
2000003 SANTROSE | 10933.67876 | 270,818.20 INR
and dont want to show INR every time with each currency amount
Edited by: PPShinde on May 24, 2011 12:16 PM
Anshu Lilhori replied
Please make a new formula And put amount in it like this
NODIM(Amount) this function will be available under datafunctions when you will create a formula.
Also use NODIM for cane if INR is coming against it.
This function will help you in removing your unit and currency from you keyfigure and once done with it then use this new amount in your third column
Make a new formula of dvision with new cane and new amount.
After folowing the above steps you will be able to get the values.
Hope it helps.
Edited by: AL1112 on May 24, 2011 12:33 PM