Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 13 periodes.
And I have also a table with many variables.
Now I want that when I select period 4, that there is a variable who have the sum of the omzet of periode 1, 2, 3 and 4.
Is that possible? And what is the formula?
Can you post a sample file?
Can you explain your requirement with sample data and post expected output
@Jonathan Penuliar and @anbu cheliyan;
I try to do that, but it is not easy.
1 2
1: The table. And in this one I want to fill in: total till this periode. But I don't know the formula.
2. All the periods. If I press on the 6 I see the datainformation of that period.
For example I have €100 demand in period 6. €50 in period 1,3 and 4, €60 in period 2, €110 in period 5. All in MAX Year = 2015.
I want that the formula if I press by period on 6. That the formula sums all the demands = €420
But what is the formula?
In set analysis you can do something similar to below:
count({<Date_In = {'>=$(=date($(vStartDate)))<=$(=date($(vEndDate)))'}>}COUNTER)
replace Date_In with Period.
vStartDate will be Period 1
vEndDate will be your selected Period
or do something like
Sum({<Period = {'<= vPeriod'}>}Demands)
It do not work.
Hi,
what do you mean by do not work ???
It is not giving you data or giving you wrong sum.
Clearify your requirement.
Try
Sum({<Period={"<=$(=max(Period))"}}>}Demands)
regards