PXFormula Concat Decimal and String

Instead of using PXFormula to run the calculation, set [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] on your string field DAC definition and use the FieldDefaulting event handler to set the concatenated value into your field. This way you can handle the casting, etc.

Also put [PXFormula(typeof(Default<decimalField>))] on your string field DAC definition, referencing the decimal field. If the decimal changes, the defaulting event will run again for the string and display the new decimal value (providing the decimal field is committing changes).

​@darylbowman Thank you for your reply and a new direction to try. I added this method to a QuoteMaint graph extension:

protected virtual void CRQuote_UsrLeadDaysDesc_FieldDefaulting(PXCache sender, PXFieldDefaultingEventArgs e)
        {

            e.NewValue = "my new value";

        } 

And I modified the field definition to:

[PXString(60)]
[PXUIField(DisplayName="Lead Days Description")]
[PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]
[PXFormula(typeof(Default<usrRevLeadDays>))]

I am worried that any or all of these factors are the reason I get no data in the field where I am looking for it:

1. CRQuote is a Projection, so maybe there is something I need to do with the Standalone?
2. UsrRevLeadDays is non-persisted, so maybe it won’t trigger FieldDefaulting events?
3. The place I want the value to appear is in the Email Template used when you click the Send button on the CR604500.rpx report. The Email Template is using screen CR.30.45.00, which uses the QuoteMaint graph, but I’m not sure FieldDefaulting events on QuoteMaint are triggered when this email template is building?

In the basic Sales Quotes GI, I am displaying UsrLeadDaysDesc and it is always empty as well, but I expect that it should be blank because the QuoteMaint graph is not involved in the GI display? Is there another place I can check the FieldDefaulting event is working? I also tried adding the field to the Sales Quotes form just to see if it filled in and it was still blank:

You need to set e.Cancel = true in the event handler to overwrite the default value assigned by the [PXDefault] attribute.

I’m a little confused. The decimal field is unpersisted, but you’re attempting to use the resulting value in an Email Template? How is the decimal value going to be set?

​@darylbowman Sorry, I oversimplified in the attempt I showed. My first try looked like this and also gave me a blank description:

protected virtual void CRQuote_UsrLeadDaysDesc_FieldDefaulting(PXCache sender, PXFieldDefaultingEventArgs e)
        {
            e.NewValue = "my new value";
            e.Cancel = true;
        }   

UsrRevLeadDays coalesces CRQuote.UsrLeadDays (a user-specified override) with UsrQuoteRevision.LeadDays (a stored calculation). The SQL looks like this:

select  
	[CRQuote_CRQuote].[UsrLeadDays], 
	ISNULL(
		[CRQuote_CRQuote].[UsrLeadDays],
		(
		  SELECT
			TOP (1) [UsrQTRevision].[LeadDays]
		  FROM
			[UsrQTRevision] [UsrQTRevision]
		  WHERE
			([UsrQTRevision].[CompanyID] = 2)
			AND ([UsrQTRevision].[CompanyID] = 2)
			AND (
			  [UsrQTRevision].[QuoteNbr] = [CRQuote_CRQuote].[QuoteNbr]
			  AND [UsrQTRevision].[RevNbr] = [CRQuote_CRQuote].[UsrRevNbr]
			)
		  ORDER BY
			[UsrQTRevision].[LeadDays]
		)
	  ) AS [UsrRevLeadDays]
from CRQuote [CRQuote_CRQuote]

​@darylbowman We got there, thank you so much!

I did have PXFormula on the string DAC function. The UsrQTRevision.LeadDays decimal is persisted through a custom form, and the CRQuote.UsrLeadDays decimal is in the QuoteMaint form, but CRQuote.UsrRevLeadDays isn’t (PXDBCalced), and neither is UsrLeadDaysDesc. I did want to return something without changing the decimal, so I changed to PXUnboundDefault:

[PXString(60)]
[PXUIField(DisplayName="Lead Days Description")]
[PXUnboundDefault]

And changed the FieldDefaulting handler to a FieldSelecting handler in QuoteMaint:

protected virtual void CRQuote_UsrLeadDaysDesc_FieldSelecting(PXCache sender, PXFieldSelectingEventArgs e)
        {
            CRQuote row = e.Row as CRQuote;
            if (row == null) return;

            var rowExt = row.GetExtension<CRQuoteExt>();

            switch(rowExt.UsrRevLeadDays){
              case null:
                e.ReturnValue = "";
                break;
              case 0:
                e.ReturnValue = "All items in stock";
                break;
              case 99:
                e.ReturnValue = "Lead time is negotiable";
                break;
              default:
                e.ReturnValue = rowExt.UsrRevLeadDays + " working day(s) to ship";
                break;
            }
        } 

This is working great and is so much easier to deal with than the BQL I was working with. Thank you again for your expertise and patience.