Forecast with current date

[#1]

Hi all!

I have value SALES - it is Fact.

I want calculated SALES_forecact on another day.

I want use this formula SALES_forecast = day(1-31 for example January) * SALES/ count(day this month)

SALES for example 100

If am choose 15 day in January i have 100*15/31

If am choose 28 day in Marth i have 100 * 20/31

Why can help me

[#2]

Hi,

Try this,

Sales* (getselectedfield(day(datefield))/ getselectedfield(Max(day(datefield)))

[#3]

Thank ' s but that is getselectedfield - is function - i don't fund this or that do you mind.

max(day(datafield) - is good work but if a do

sales * day(datafield)/max(day(datafield)

i don't show value for all month , a can show only if day is choose

[jonathandienst]

Hi

If month and day are in your dimensions, then something like this should work:

Sum(sales) * day(datafield) / Max(TOTAL <month> day(datafield))

Remember that QV field names are case sensitive, so [sales] is a different field than [SALES].

HTH

Jonathan

[jonathandienst]

Or better

Sum(sales) * day(datafield) / day(MonthEnd(datafield))

[#6]

Thank you, Jonathan!