Sign Up ›
  • Pablo Rodríguez
  • NEWBIE
  • 0 Points
  • Member since 2018
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 3
    Replies
4 replies

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))
4 replies

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))