I created two formula fields in my Data Stream:
- One returns Text
- One returns Number
Both are derived from the TotalAmount field in the Order object.
In Data Explorer, all three fields (the original TotalAmount and the two formulas) show correct values.
But when I try to use these fields in a Batch Data Transform → Transform Node → Formula Field, I cannot see any of them when applying the LAG function.
Additionally, I noticed that Currency fields are not supported in the transform node for LAG.
So even though the values are correct in Data Explorer, they are not available for window functions like LAG inside Batch Data Transforms.
How can I handle this scenario if I want to forecast using TotalAmount?
: Data Cloud uses the static exchange rates and currency codes defined in your CRM org for processes like data transforms, segmentation, and calculated insights.
In a single-currency organization, Data Cloud syncs its currency data from your Salesforce org via DLO named Static_Currency_Rates_<CRM orgID>. This gets synced automatically, so you can check if you see your desired details in this DLO. If not, this is where we need to focus.
In a multiple-currency organization, Salesforce creates a data stream named Static_CurrencyType_<CRM orgID>. Each CRM org manages its own currencies and conversion rates. Here you can check if the number of records (i.e. currencies) are same in both DLOs. If not, this is what we shall focus.
More details are here:
https://help.salesforce.com/s/articleView?id=data.c360_a_multi_currency_how_it_works.htm&type=5Please check, and let me know of these, then we shall be able to explore this further.
