1

IF formula trouble

I'm trying to do the following:

 

If (Transaction Code = "NWP" OR "GWP",BLANK, (Measure - Amount/ Datapoint - Amount where Transaction Code = GWP)*-1)

 

At moment this is a picture of my formula - I can get % Of Total for all transaction types showing (false part) but can't make NWP /GWP transaction types blank (true part)

 

Any help much appreciated.


Thanks

Nick

2 replies

null
    • imbarmarinescubar_pyram
    • 4 yrs ago
    • Reported - view

    Hi Nicholas Campbell ,

     

    I think you are looking to check the caption. And use "||" as an "or" condition. Something like this should work:

      

    • Ramon_Griffin
    • 4 yrs ago
    • Reported - view

    how would you incorporate multiple if statements?

Login to reply

Content aside

  • Status Answered
  • 1 Likes
  • 4 yrs agoLast active
  • 2Replies
  • 69Views
  • 3 Following