How can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN

[neg177]

Hi,

Would like to know how can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN formatted. What I'm trying to do is put conditions on my Row's A+/A++...ect to determine what number (6,9,12..ect) they will fall under. I have a pic attached. Please advice. 

Thank you 

[rob_marshall · Accepted solution]

@neg177 

Just set this up like a Mapping module, change the format to boolean and check the appropriate selections.

Rob

[neg177]

By Mapping Model you mean Just make my List Items into the Line Items and my Numbers as well and then do the conditions? 

[rob_marshall · Accepted solution]

@neg177 

I was actually thinking this:

 I guess it depends on what you are attempting to do.  I was "thinking" you were trying to figure out what is "valid".  Again, more of a mapping module.

If you need to see the values by a particular month/timeframe, then you can add time to this module and use ANY to populate it from a transactional module.

Rob

[neg177]

OOOHH I see what you are saying. That was very helpful! 

Thank you