You need to sign in to do that
Don't have an account?
ARUN JOY
Not able to write a formula ( Row level formula) in SF Lightning reports
Im trying to build a report on lead object where I have to show the a report where maximum lead happened from specific 6 digit postal code location . So I need to to remove last 3 digits of postal code and show first 3 digits of postal code on the report , group it and display it in charts . I tried to write a formula ( by adding a row level formula) but not able to validate the formula .
Formula i wrote is
LEFT(Zip/Postal Code,LEN(Zip/Postal Code)-3)
But validation is failing ?
Can someone guide me on this.
Formula i wrote is
LEFT(Zip/Postal Code,LEN(Zip/Postal Code)-3)
But validation is failing ?
Can someone guide me on this.
What is the error message which you get?
Thanks,