You need to sign in to do that
Don't have an account?
Jasmeen Kaur 22
Append Numbers or Percentage in one field from another field.
Hi Experts
How can i create a formula to Append Discount fileds (Percentge or number)
Actually the case is,
On Case Object, I created a field "Discount" and "Discount History". In our organisation, time to time we offer certain value of discounts to our customers and I tried creating something to track the discount history like when was the last discount given to this account and last discount value using this formula.
$User.LastName + ', ' + $User.FirstName + ' ' + TEXT(Today()) + ' - ' + Discount__c + BR() + BR() + Discount_History__c
"But I am getting error that expected TEXT and recieved number" because discount is a number.
Any help will be highly appreciated.
Thanks
How can i create a formula to Append Discount fileds (Percentge or number)
Actually the case is,
On Case Object, I created a field "Discount" and "Discount History". In our organisation, time to time we offer certain value of discounts to our customers and I tried creating something to track the discount history like when was the last discount given to this account and last discount value using this formula.
$User.LastName + ', ' + $User.FirstName + ' ' + TEXT(Today()) + ' - ' + Discount__c + BR() + BR() + Discount_History__c
"But I am getting error that expected TEXT and recieved number" because discount is a number.
Any help will be highly appreciated.
Thanks
Used the TEXT() around the discount field TEXT(Discount__c)
TEXT() converts a Percent, Number, Date, Date/Time, picklist, or Currency field into Text.
reference
https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/text_formulas
Regards
Andrew