thank you it work
can i have another help?
i kindly figure how the logic work but i have trouble with duration in days
so my formula is IIf(Isnumeric((Number3/Number16)*480);(Number3/Number16)*480;[Remaining Duration])
i already use isnumeric and isdate but it still show #error
which fuction should i use to show remaining duration?