Search
Search

# BEx Query Designer - working on fields calculations

Dear all,

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 :

Material |--- CANE

| Cane / Amount--

| 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

Regards

Pumam

Edited by: PPShinde on May 24, 2011 12:16 PM

##### Anshu Lilhorireplied

Hi ,

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.

Regards,

AL

Edited by: AL1112 on May 24, 2011 12:33 PM

0 View this answer in context
View more on this topic or