topic Re: Value List & measure in App Development

Value List & measure

jacekp — Fri, 12 May 2023 06:20:25 GMT

Hi,

I would like to have 3 different calculation based on the dimension in Valuelist:

Dimension:

ValueList('A','B','C')

Measure:

=if(ValueList('A','B','C')='A', 1,
if(ValueList('A','B','C')='B',[Demand_DOS_>0<=14]
,[Demand_DOS_>14<=45]))

I am using master measures to get it clean.

Individual master measures work fine and return correct numbers.

[Demand_DOS_>0<=14] = 100

[Demand_DOS_>14<=45] = 50

I don't get this behaviour:

a) if "measure" looks like that, returns table:

=if(ValueList('A','B','C')='A', 1,
if(ValueList('A','B','C')='B',[Demand_DOS_>0<=14]
,[Demand_DOS_>14<=45]))

A =1

B=0

C=0

b) if measure looks like that, returns table:

=if(ValueList('A','B','C')='A', [Demand_DOS_>0<=14],
if(ValueList('A','B','C')='B',1
,[Demand_DOS_>14<=45]))

A = 100

B = 1

C = 0

Seems like master measure works only on first condition, if it is on another place it won't work

Can someone suggest any workaround ?

Re: Value List & measure

Chanty4u — Fri, 12 May 2023 06:33:45 GMT

Try this

=if(ValueList('A','B','C')='A', 1,

if(ValueList('A','B','C')='C',[Demand_DOS_>14<=45],

[Demand_DOS_>0<=14]

))

Re: Value List & measure

jacekp — Fri, 12 May 2023 06:36:21 GMT

It returns:

A = 1

B = 0

C = 0

Re: Value List & measure

Chanty4u — Fri, 12 May 2023 06:42:16 GMT

Can you try this

=if(ValueList('A','B','C')='A', 1,

if(ValueList('A','B','C')='B',[Demand_DOS_>0<=14],

if(ValueList('A','B','C')='C',[Demand_DOS_>14<=45], 0)

))

Re: Value List & measure

jacekp — Fri, 12 May 2023 06:48:57 GMT

still returns only A = 1, B & C = 0

master measure looks like that:

sum(

Date = {"$(vD_Month_N6M)"}

aggr(

if(

(

Sum(

Presentation = {"AC Unrestricted","InTransit"}

Value)

(

Sum(

Date = {"$(vD_Month_N6M)"},

ValueType = {"Demand"}

$(vValue))

))

*30

and

(

Sum(

Presentation = {"AC Unrestricted","InTransit"}

Value)

(

Sum(

Date = {"$(vD_Month_N6M)"},

ValueType = {"Demand"}

$(vValue))

))

*30

<=14

Sum({<Date = {"$(vD_Month_N6M)"},ValueType = {"Demand"}>}$(vValue)),0)

,[Material ID]))