Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dataset which has name, date and values.
I want the result as attached in the sample data excel.
The formula for result is for the first time it's 1*(value1+1) - for 2nd iteration it's --> result * (value2 +1) - for 3rd iteration it's --> result * (value3 + 1) and so on.
Thanks
Try this,
tab1:
LOAD *, Alt(Peek(Result),1)*(Values+1) As Result;
LOAD Name,
Date,
Values
FROM
[D:\HereDownloads\Sample data (2).xlsx]
(ooxml, embedded labels, table is Sheet1);
Try this,
tab1:
LOAD *, Alt(Peek(Result),1)*(Values+1) As Result;
LOAD Name,
Date,
Values
FROM
[D:\HereDownloads\Sample data (2).xlsx]
(ooxml, embedded labels, table is Sheet1);
Thanks Saravanan, works like charm.