IntervalMatch and multiplication

[ali_hijazi]

Hello

I got a pivot table in which I have expressions whose values are calculated via IntervalMatch

for now everything is going on just fine

however there is one expression whose value after being got by intervalMatch I want to multiply it by -0.15; is there a way to do this multiplication on the fly?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

The result of the IntervalMatch() Load is just another table. You probably need, though, to load that resulting table again and multiply by that figure, or you can do it in the chart expression as well.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[ali_hijazi]

how can I do this in the chart expression?

I can identify the row by a value of the dimension

but how can I get to the value of the related expression?

[Miguel_Angel_Baeyens]

Hi,

If you are working in the same chart, just label your expression and use the expression between brackets anywher in another expression.

If you are working in a different chart, you need to write the same exact expression in both charts.

In both cases, you can multiply the field by -0.15

For example

Sum(Field * -.15)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica