Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this,
Sales* (getselectedfield(day(datefield))/ getselectedfield(Max(day(datefield)))
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
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
Or better
Sum(sales) * day(datafield) / day(MonthEnd(datafield))
Thank you, Jonathan!