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.
Hi Ajit
By current month do you mean todays date if so try
datepart('month',Now())
You may need to average this if you have multiple lines of data and/or your Profit % is pre aggregated
avg(datepart('month',Now()))
Or is current month the month on the row of data. if so try something like
datepart('month',[YOUR DATEFIELD])
Darren