Skip to main content
Topics#Data ManagementQuestion de Emily Walsdorf
Emily Walsdorf a posé une question dans #Data Management
30 juil. 2018, 21:37

Can I reference a boolean formula in another formula?

Hey Community - I'm trying to reference a boolean formula in another formula, and I'm thinking it's the reason I'm not getting the answer correct.  See formula (X and Y are other boolean formulas):

 

IF(AND(  X  = TRUE,

 

Y = FALSE,

 

Z =null), 1 ,2)
8 réponses
  1. Sunil Sarilla (M&G Investments)
    30 juil. 2018, 22:18
    could you please confirm if you have selected treat blank fields as blanks under the blank value handling section

     

    could you please confirm if you have selected treat blank fields as blanks under the blank value handling section if say Simplu Adjusted Monthly Plan value is 0 what do you want formula to return?

     

    if say Simplu Adjusted Monthly Plan value is 0 what do you want formula to return?
Rédiger une réponse...
0/9000