I am creating a formula something like this –
((98-Profit %) /3)* Number of current months ?
I am not able to understand what should be the formula for getting Numeric value of Number of month. Example if the current month is October then 10 should come there, if March is the current month then 3 should come there.
Please help me on this.
By current month do you mean todays date if so try
You may need to average this if you have multiple lines of data and/or your Profit % is pre aggregated
Or is current month the month on the row of data. if so try something like