Expression Calculation

[sarasmonu]

Hi Team,

I am trying to do the below calculation:

(Latest Date Information - Information entered 14 days ago)/Information Entered 14 days ago

If we do have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first available information .

Please help me in doing the above calculation.

Thanks,

Monu

[YoussefBelloum]

Hi,

I think you wanted to say:

If we do NOT have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first available information .

Right ?

can you attach some data here ?