Put a measure value into a number variable

[paulcalvet]

Hello,

I try to retrieve a measure value and store it into a variable.

It works with a string variable but not with a number !

The output is always 0, I try to convert, replace space by "", multiply by one, etc.. 

Here is the log : in text it works

In number it doesn't work :

Please help I don't find the solution !

You can find attached the automation.

Regards,

Paul

[rubenmarin]

Hi, it looks like the measure has 2 numbers separated by an space, maybe that's the cause it can only interpreted as a string.

I've tested the automation with the ctrl+00 script and it works

[paulcalvet]

Yes,  it's certainly the format number.

But when I try to convert it or to remove space from string, it doesn't work.

I will try it with a measure without format, but It's a bad workaround to duplicate measure.

[rubenmarin]

Hi, I tested but I didn't know either how to remove spaces in the text using the automation, but instead of duplicating the full expression you can create another expression that just removes spaces from the original measure, like creating a Non_space_Measure that has the expression:

PurgeChar(Original_Expression_Name, ' ')

At least if you change the expression formula you only need to update the original.

Or wait for someone with more knowledge than me about how to do the same in automations.

[marcus_sommer]

Formatting is useful for a human viewing but on a programmatic process it's the opposite of helpful ...

[paulcalvet]

In this use case, I work in managed space so I can't create new measure, and I'm not in favour duplicate objects to manage number formating 🙂

Maybe a moderator can help ?

@Jeffrey_Goldberg do you know how we can use a measure in automation when this measure have a format ? in my case, the result is understood as a string.

Regards,

Paul

[AfeefaTk]

Hi @rubenmarin 

@paulcalvet 

Could you please let me know what exactly you are trying to achieve here?

Regards

[rubenmarin]

Hi @AfeefaTk it looks like theree is a variable with a number stored using an empty space as thousand separator, probably this causes to be readed as two diffrent values, which returns null(), and the possible solution would be to add an step in automation that removes the space or interprets the space as thousand separator so the value can be readed as a number.

[AfeefaTk]

Hi @rubenmarin 

So you have a solution using automation?
Its working for you?

Or do you need any help here?

Regards

[rubenmarin]

Hi @AfeefaTk, thanks for your quick answer... I was just summaryzing the thread. @paulcalvet is the one that needs the solution. Let's wait to confirm if @paulcalvet has a solution or still needs help.