Range Product Formula

m_perreault — Sat, 16 Nov 2024 06:33:01 GMT

Hi All,

I have the below data

The for set time frames (such as QTD,YTD,etc.) I need to create a formula such as the one below. This would be for QTD

(Aggr(Sum({<[Period] = {'Dec - 2018'}>}Value)+1,Period) *

Aggr(Sum({<[Period] = {'Nov - 2018'}>}Value)+1,Period) *

Aggr(Sum({<[Period] = {'Oct - 2018'}>}Value+1,Period))-1

so my formula would = ((-.74+1)+(-.33+1)+(.22+1))-1 = -.0845

Does anyone have an idea of how to make this formula dynamic for a set period ?

topic Range Product Formula in App Development