CCC_We want to dynamically change the formula for a Total based on the Month of the Calendar Year
Hi Team,
We have a formula Cell in FRS Report where the sum is multiplied by the Number of Months.
Right now the formula is Static, but we need the formula to dynamically
change based on the Month for which the report is being Run.
Ex: Accounting Year Jun-May, If the Report is Run in July the Sum
Should automatically multiplied by Two. Like wise for Aug it should be
multiplied by Three.
Thanks,
Ahmed.