dynamic variable in expression

[Emil_bros]

Hi,

I have following datamodel loaded:

"

load
GPSI_Version,
GPSI_Month,
GPSI_Constrained_Q,
ApplyMap('Map_Accuracy',GPSI_Version, null()) as Official_PSI

FROM
[$(QVDDir)GPSI*.qvd]
(qvd)
;

"

I need to get this result into one line (without Official_PSI dimention😞

I am trying following expression but it returnes 0.

sum(if(GPSI_Month = Official_PSI, GPSI_Inventory_WH_Q))

Any ideas where am I wrong?

Emil

[sunny_talwar]

Removing Official_PSI dimension should do it for you, wouldn't it?

[Emil_bros]

that is my goal but I only get empty table when removing Official_Psi dimention

[sunny_talwar · Accepted solution]

Is this your expression?

or this?

sum(if(GPSI_Month = Official_PSI, GPSI_Inventory_WH_Q))

The first one would not work... but the second one should work... if it doesn't would you be able to share a sample where we can see the issue? 

[Emil_bros]

I am  using :

sum(if(GPSI_Month = Official_PSI, GPSI_Inventory_WH_Q))

also surprised it's not working.

I'll try to prepare sample but actual report is quite complex (90 MB) so no that easy to extract just this case.

[sunny_talwar]

Difficult to say without looking at this.

[Emil_bros]

problem solved. Dimentions weren't formatted as date.

Thank you for the help.