Make data to null

[bharatkishore]

HI All,

@sunny_talwar 

I have 2 tables and i have a derived contract flag and these columns from second table:

[Sales Document] as Sales.Document_Contract,
Item as Item_Contract,
Equipment,
Date(Start_DT_New,'MM/DD/YYYY') as Start_DT_New,
Date(End_DT_New,'MM/DD/YYYY') as End_DT_New,
MaterialEntered

Now i have written an expression to get contract flag i.e. 

if(Posting.Date>=Start_DT_New and Posting.Date<=End_DT_New,'Contract Period','Outside Contract Period' )as Contract_Flag

Now where ever the i get Outside Contract Period i want all the above mentioned columns to be null.

Can you please help me how to achieve it.

Thanks,

Bharat

Attaching qvw for reference.

Please let me know if you need anything more

[anushree1]

i see it working when Contract Flag ->Outside Contract Period Selected the Table is blank

else it shows the relevant records.

Please check the code starting from Noconcatenate in the attached file.

Please let me know if you were looking for some other output

[anushree1]

i see it working when Contract Flag ->Outside Contract Period Selected the Table is blank

else it shows the relevant records.

Please check the code starting from Noconcatenate in the attached file.

Please let me know if you were looking for some other output

[bharatkishore]

Thank you Jamie.. Worked perfectly... But only problem is for few columns data is matching and few other equipments data is not matching

[bharatkishore]

Thank you Anushree for your time.. Jamie code worked.. thanks once again..