sumif alternative for formula

[Former Member]

Hello

I am trying to do a formula for a calculated meaure that look something like:

sum(MeasureA for DimensionX='01')/sum(MeasureB for DimensionX='01')

I see i can use Sum({Sales}) ForAllExcept [{Product}] as in the user guide but I can not specify the Value in the Dimension. Also saw Runningsum but still not what i need

Any suggestions ?

Kind Regards

Hector

[ashutosh_rastogi · Accepted solution]

Hi Hector,

You can create a custom calculation in Lumira like below, I tried and this works

Sum(if ({DS1.City (DIM)} = "Austin") then {DS1.Quantity sold} else 0)/Sum(if ({DS1.City (DIM)} = "Dallas") then {DS1.Quantity sold} else 0)

Regards,

Ashutosh

[Former Member · Accepted solution]

Hello Ashutosh

I am currently using Lumira 1.28 because we use Lumira Cloud . I seems to Create a custom calculation it needs 1.29 but these version is not compatible with Lumira Cloud. What do you suggest ?

Kind Regards

Héctor Santos

[ashutosh_rastogi · Accepted solution]

Lumira cloud is not supported with 1.29 Lumira Desktop release. I don't think it would be possible with 1.28.

Regards,

Ashutosh