Hi all i have problem in chart calculation
for 1st row of calculation i.e., for date 28/12/18 which is a dummy record joined with the fact table so for
each fund(a,b,c....) the 28/12/17 were added, for all funds with 28/12/17 as 1st row and calcualtion i need is (Qty/nv)*Rate and
from 2nd row and above (above of calulation field) /(1+Coresponding level field values)
Date Qty/Nv level Rate Value(Calculation)
28/12/18 11.2 3 11.2*3=33.6 (only for 1st row i.e., for date 28/12/18 calculation (Oty/nv)*Rate)
27/12/18 22.2 40 4 33.6/(1+40)=0.81 from 2nd and above the calculation is (Above(Value)/(1+coresponding level)
26/12/18 32 50 6 0.81/(1+50)=0.66 continue as above..........
'Value' field is an expected output
Please provide sample data? At least few rows in excel
How long this rows got Break? What if you have 100 Rows with Different Rows? Can u explain relate the Live data as well..
Actually i cant tel the exact data its confidential ,i have fund field wchic conatind 120 funds in it ,each fund end with 28/12/17
so for each fund for date 28/12/18 calculation must be Price *star ,the date is arranged in ascending order
from 27/12/18 the calculation is
|i.e.,previous value of Calculation part divided by (1+coresponding level value )|
its quit triky i thnk,but hope u understoad my requiment now atlest
We can use If..Else condition, But it's long process to achieve. Instead if you make 10 Rows and expected result that would give right way..