We have a Custom Setting field that contains a value which we update on a regular cadence. With the release of Row Level Formulas on Reports we suddenly have several reports that need to reference this value in a Row Level Formula.
Instead of hard coding the value in these formulas and needing to update each of them every time the Custom Setting field is updated, I would prefer to reference the setting in the formula like I can when creating Formula fields.
Unfortunately I have not found any documentation referencing this nor found any way to do it while testing in a formula.
I have tried the following but gotten validation errors each time:
Custom_Setting__c.Field_Name__c Setup.Custom_Setting__c.Field_Name__c $Setup.Custom_Setting__c.Field_Name__c
My instinct is telling me that because Row Level Formulas are so new (and maybe considered beta? I forget) that this might not be rolled out yet.
Does anyone know if there is a way to reference a Custom Setting value from within a Row Level Formula?
A workaround would be to create a Formula field on the Objects that are being reported on that references the Setting, however I would prefer to not create a bunch of Formula Fields unless necessary.