Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculated column is giving wrong result

Hi,

I want to create 2 new calculated columns like follows

            incoming = if [Debit/Credit] = S  then  [amount in company code currency]

            outgoing = if [Debit/Credit] = H then  [amount in company code currenty]*-1

 

I have used the below formulas

Outgoing = IF ( SAP_BSEG[Debit / Credit]="H", SAP_BSEG[Amount in company code currency]*-1,BLANK() )
Incoming =  IF ( SAP_BSEG[Debit / Credit]="S", SAP_BSEG[Amount in company code currency],BLANK())
 
for some values it's showin the right result but for some values it's showing the wrong values like below
 
 
 
My expected result is for example
 
 
Please help me with this
 
 
 
 
Need Help

6 Replies

  • novilpawar's avatar
    novilpawar
    Icon for Advocate I rankAdvocate I
    7 years ago

    Anonymous  Hi,

     

    Are credit and debit is same as incoming and outgoing? If it is same then it should be working fine. It worked for me.

    another question is Are credit and debit Calculated column or Measures?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I don't know how I am getting the wrong values, but when I used the same data in a fresh pbix file the values are coming correct but in my existing if I implement the same logic wrong values are coming.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        can anyone help me how to write the below query in M language

         

        Outgoing = IF ( SAP_BSEG[Debit / Credit]="H", SAP_BSEG[Amount in company code currency]*-1,BLANK() )