Hi, I need help to create a calculated member.
I need to do exactly what the SUM function does but multiplying instead.
How can I do that?
Something like
Multiply({PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember},
[Measures].[Story Points resolved]
)
Hi @Tatiana_Ottenio,
There is no such function that multiplies all the set members. Howevere, basic mathematical operations for adding +, subtracting -, multiplying *, and dividing / are applicable for calculated measures.
You may multiplay individual values using the mathematical operation * (https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference#MDXFunctionReference-Operators).
This is quite an unusiall requirement to multiplay many values over time. Could you give a use case of what are you trying to calculate and what report you are building?
You might want to check out the standard calculations, probably the function you are looking for is already there: https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure.
Best,
Zane / support@eazyBI.com