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
Brandon Stys 8Brandon Stys 8 

Newbie Question: IF Statement using number field

Newbie Question: I am trying to write an IF statement in a report using a number field. IF( NUM Field = 4, IF TRUE, Or FALSE). For some reason I can not get the logical statement to work. The field i am using is Quarter__c but it says that the field does not exist. Any help is recommended. Thank you :)
Mario EMario E

Check the report type of the object you are trying to pull the report on and see if Quarter__c has been added to that record type.

 

By the way, shouldn't the formula be: 

IF(Quarter__c = 4, TRUE, FALSE)
Brandon Stys 8Brandon Stys 8
i have tried the formula you listed and it says the field does not exist. The object does not have any record types. The field can be validated when i use the insert button and get Demographics__c.Quarter__c:SUM. i have also tried Demographics__c.Quarter__c and it didnt work either.