Hi all,
We have a scenario to calculate the diff between two dates. By using formula variables, I am able to subtract the dates. But, it gets complicated when one or both the dates is " # ". The requirement is to display " NA " , in such a scenario. How do I accomplish this ?
Any clues on this will be extremely helpful. Thanks a lot !!
Regards
Niranjana
Hi,
Yes, the problem is there when any of the date is not available; to acheive this,
create a third Keyfigure, and write a characteristic routine in the Transformations by using the Logic: substract the two dates, if any of the date is not available then insert the result as NA
Regards
ReddY A
Add a comment