We want to dynamically change the formula for a Total based on the Month of the Calendar Year(FRS)

Summary:

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.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):