Forum Discussion

newkingdom's avatar
newkingdom
Frequent Visitor
4 years ago
Solved

Get only the payment amount from the same table

I have a basic table with a sales Id, Amount, Type activity. I want to create a new column in the table which will just return the Payments. So type = Payment, otherwise it will return a 0 for the ot...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi newkingdom 

     

    You can create a calculated column in this case:

    Payment Amount  = IF(
                                          TableName[Type] = "Payment",

                                           TableName[Amount], 0)

    I just tested this on my data and it worked. If the data-type of Amount is Number use 0, otherwise use "0"

     

    If you think my solution worked , please 'Accept' it as a solution and give it a like.

     

    Thanks,

    Mahesh

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi newkingdom 

 

You can create a calculated column in this case:

Payment Amount  = IF(
                                      TableName[Type] = "Payment",

                                       TableName[Amount], 0)

I just tested this on my data and it worked. If the data-type of Amount is Number use 0, otherwise use "0"

 

If you think my solution worked , please 'Accept' it as a solution and give it a like.

 

Thanks,

Mahesh