How to club two flag conditions in one if condition expression

[trishita]

I have two flag options which I want to put under same column.Which means the column Computed ROB and Actual ROB will show in one and single column for flag values 0 and 1.However I had faced syntax error and some problems in approaching the same values...I have uploaded the qvw for the said functionality.

To be noted    Flag1=If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 8, 1, 0)

and Flag0=If([SOUNDING_START_DATE] > [SURVEY_DATE]  and [SOUNDING_START_DATE] > [SURVEY_DATE] + 8 and [SOUNDING_START_DATE] < [SURVEY_DATE] + 30, 1, 0).

​I am trying to computed the values of COMPUTED ROB and ACTUAL ROB values for same quantity but for two different time range.

[trishita · Accepted solution]

corrected

If( Flag0=0,[Computed ROB1], [ComputedROB2])

where Flag0=If([SOUNDING_START_DATE] > [SURVEY_DATE]  and [SOUNDING_START_DATE] > [SURVEY_DATE] + 8 and [SOUNDING_START_DATE] < [SURVEY_DATE] + 30, 1, 0)