Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How to build the following chart :
Input | |||||
Trading Day | 1 | 2 | 3 | 4 | 5 |
Sales | 500 | 1000 | 2000 | 500 | 1000 |
Budget | 0 | 0 | 20000 | 0 | 0 |
Budget=20000/5 is 4000 | |||||
Output | |||||
Trading Day | 1 | 2 | 3 | 4 | 5 |
Sales | 500 | 1500 | 3500 | 4000 | 5000 |
Budget | 4000 | 8000 | 12000 | 16000 | 20000 |
Please find the attachement sample
In the sample model . I am using vPerFormula and vPerFormulaBud to calculate the sales and budget resp.
Input | |||||
Trading Day | 1 | 2 | 3 | 4 | 5 |
Sales | 500 | 1000 | 2000 | 500 | 1000 |
Budget | 0 | 0 | 20000 | 0 | 0 |
where Sales is calculated with the help of variable , eg , vSales
vSales = sum({$<TranType = {'Sales_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)
vBudget = sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)
Can anyone tell me how to write the following expression :
LOAD Sum(Budget)/Count(Budget) as Budget1
as vBudget / count(vBudget ) is also not working
and
Method 2 is RangeSum(Above()) Method:
=RangeSum(Above(vSales ), 0, RowNo()))
=RangeSum(Above(vBudget), 0, RowNo())) are not working
Wow! this is huge file. Were you not able to reduce the application size for uploading purposes?
The file is too big.
What if every question has an attachment of some hundred megabytes?
Sales Value is calculated a variable :
vPerFormula : sum({$<TranType = {$(vAmountType)},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)
Budget Value is calculated a variable :
vPerFormulaBud : sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)
How to use this variables in the cummulative sum .
as Sum(Budget)/Count(Budget) as Budget1
and
Method 2 is RangeSum(Above()) Method:
=RangeSum(Above(Sum(Budget1), 0, RowNo()))
=RangeSum(Above(Sum(Sales), 0, RowNo()))