Calculation of Total Days

[Anonymous]

Hello All,

I am attaching a sample excel file to calculate TotalDays which I have calculated in excel with following formula:

=IF((F10-C10)<0,F10/C10*30,

IF((F10-C10-C9)<0,((F10-C10)/C9*30)+30,

IF((F10-C10-C9-C8)<0,((F10-C10-C9)/C8*30)+60,

IF((F10-C10-C9-C8-C7)<0,((F10-C10-C9-C8)/C7*30)+90,"<120"))))

Now I have to apply same logic in Qlikview.

Can anybode suggest or help to do same at script level or front end?

Need a quick response.

Regards,

Balraj