function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Pablo RodríguezPablo Rodríguez 

OWNER ID FORMULA

Can someone tell me what am I doing wrong with the following formula? The formula hasn´t a sintaxis error, but, I´m not getting a percentage as answer,, Im getting 0.

if( text(Status)="Baja",0,

if(and(text(Ciclo__c )= "Fall 2020", (OwnerId)="Brenda Monzalvo"),1/35,

0))
@anilbathula@@anilbathula@
Hi Pablo,

The problem is you are checking ownerId with name.
Change the formula to below:- 
if( text(Status)="Baja",0,

if(and(text(Ciclo__c )= "Fall 2020", (Owner.Name)="Brenda Monzalvo"),1/35,

0))

Thanks
Anil.B
Pablo RodríguezPablo Rodríguez
Ok thank you Anil,  :(

Salesforce took it as incorrect. It ask me to specify a type of object for Owner .

In this case, Brenda is a User.If I enter the formula as the beggining, salesforce take it as a correct one. But it doesn´t give me the % that I´m asking for......

if( text(Status)="Baja",0,

if(and(text(Ciclo__c )= "Fall 2020", (OwnerId)="Brenda Monzalvo"),1/35,

0))
@anilbathula@@anilbathula@
Hi Pablo,

Use the ownerId of brenda which is of 15 or 18 digit id Instead of "Brenda Monzalvo".

That will work as ownerId is an ID and you are comparing it with name.
So its going to else condition and returning 0.

Thanks
Anil.B
 
Pablo RodríguezPablo Rodríguez
Problem solved!


Thank you Anil.B