This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@jamielaird , thanks for replying. In the output what I need is that, after every 6 months the number should set to 98% of the original # , In your workflow you sent, the # reduced to 98% from 7 month, but once we reached in month 13 it showing null, what should we do to show...
Month 1 to 6 - Original # say A
Month 7 to 12 - 98% of Original say B
Month 13 to 18 - 98% of B
Month N to N - 98 % of
Also the script should check if the Months going beyond current month, then it should drop the future months columns.