OTBI Conditional Formating - Color Coding Not working

Content

Hello everyone, 

I have created passport details report. This report contains field Passport Expiration Date. I would like to color cells where expiration date is due 0-30 days, 30-60 days and 60-90 days. In order to get this calculation in terms of how many days are left before expiration, I have set up a custom calculated column "TIMESTAMPDIFF(SQL_TSI_DAY, CURRENT_DATE, "Person Passport Details"."Expiration Date")"  to use as a condition for Conditional Formating of Passport Expiration Date field.

Unfortunatley this functionality is not working properly or I am missing something, because for some fields this functionality is working just fine and for some not at all. In cases when conditional formating is refering the cell which is a subject of formating, it works just fine, but as soon as cells needs to be formated based on the value of another cell, this is where it comes unstable.