0

I need to do some math on the records in a currency column when the number isn't whole. In other words, if the number in the currency column is $10.00, I don't need to calculate; but if the currency is $5.56, I need to run a calculation. In Excel, the INT formula would make the determination — but does Salesforce offer a similar option for a row-level formula?

3
  • What is the exact scenario what formula you are using in excel ? Commented May 3, 2020 at 15:43
  • Can you please provide more information in salesforce we have formula field through which we can perform the row-level calculation. If you can provide exact scenario then it will be helpful to provide exact formula in salesforce Commented May 3, 2020 at 15:45
  • I have a solution, but thank you for asking. I was trying to calculate the original amount of a donation where the donor paid the transaction fee, since the processor charges their fee on the total amount that includes the fee so the original gift remains a mystery.
    – Cheri
    Commented May 3, 2020 at 19:17

1 Answer 1

0

If you just want to check whether a number is whole or not then you can do

(ABS(<NUMBER FIELD>) - ABS(FLOOR(<NUMBER FIELD>))) = 0 in a formula field.

If this is true then yes it is a whole number else it is not a whole number.

Example: Value = 5.5

ABS(5.5) - ABS(FLOOR(5.5))

LHS = 5.5 - 5 = 0.5  

Outcome = false

Example: Value = 10.00

ABS(10.00) - ABS(FLOOR(10.00))

LHS = 10.00 - 10 = 0 

Outcome = true

ABS will take care of the negatives.

If you want to utilize this in reports then you can sum this field.

1
  • Thank you for your help!
    – Cheri
    Commented May 3, 2020 at 19:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .