Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a set analysis formula I am using along the lines of:
sum({<Date = {"*"} >} Price)
I would like to replace the static Date in the formula with a Drill group. Does anyone know the correct syntax to replace the Date dimension with a "GetSelectedField(Date_Drill)"?
Any help is much appreciated!
Thanks
This should work: sum({<$(=GetSelectedField(Date_Drill))= {"*"} >} Price)
Not sure if you can make the GetSelectedField work inside the set analysis, but you can surely do different set analysis based on the field.
Something like this:
If(GetCurrentField(DateDrill) = 'Date1', sum({<Date1 = {"*"} >} Price),
If(GetCurrentField(DateDrill) = 'Date2', sum({<Date2 = {"*"} >} Price),
3))
This should work: sum({<$(=GetSelectedField(Date_Drill))= {"*"} >} Price)