• Ramesh Reddy Kasireddy
  • NEWBIE
  • 0 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
We are using this set of formulas to test to see if the quantity price is null. If it isn't it should be output, otherwise it is skipped.

IF(ISNULL(Product2.Qty_1_9__c),"","$"&TEXT(Product2.Qty_1_9__c)&BR())
&IF(ISNULL(Product2.Qty_10_49__c),"","$"&TEXT(Product2.Qty_10_49__c)&BR())
&IF(ISNULL(Product2.Qty_50_199__c),"","$"&TEXT(Product2.Qty_50_199__c)&BR())
&IF(ISNULL(Product2.Qty_200_499__c),"","$"&TEXT(Product2.Qty_200_499__c)&BR())
&IF(ISNULL(Product2.Qty_500_999__c),"","$"&TEXT(Product2.Qty_500_999__c)&BR())
&IF(ISNULL(Product2.Qty_1000__c),"","$"&TEXT(Product2.Qty_1000__c)&BR())),"",

The goal is to have output on a Quote:
Qty 1-9  $15
Qty 10-19  $14.45
Qty 20-39  $13.95

It works fine with one exeption: If the price ends in zeroes ($15.00) on the PDF output we are seeing is "$15.0" - the second zero is being dropped. The field involved is set up with 2 decimal places.

Is there anything I can put in this formula to force the second 0 to print on PDF output?