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
