Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have a problem with comas and points. I want to declare a couple of variable like this:
[OG_GH] = 0.505
[UG_GH] = 0.296
And then I want to use these variables in a expression.
Avg ({<Z1V1niO={'>$([UG_GH])'}>*<Z1V1niO={'<$([OG_GH])'}>}[Z1V1niO])
The problem is that in "expression" I need "," and in Skript ".".
What can I do?
Thank you for your help!!!
Eduardo
you can try out the replace function in set analysis.
replace('0.505','.',',') -> 0,505
i don't have any data where i could test it right now but I think it should work this way
avg({<Z1V1niO={'>(=replace($([UG_GH]),'.',','))'}>*<Z1V1niO={'<(=replace($([OG_GH]),'.',','))'}>}[Z1V1niO])
regards,
MT
Hi. If you treat your variables as text, then you should use REPLACE() function. If you are evaluating those values as numbers, use the NUM() and NUM#() functions with the appropiate decimal separators.
To convert the given example, you first need to interpret the dot and then switch it to comma:
NUM(NUM#([OG_GH], '#,##0.0', '.', ','), '#.##0,0', ',', '.')
Hope it helps.
you can try out the replace function in set analysis.
replace('0.505','.',',') -> 0,505
i don't have any data where i could test it right now but I think it should work this way
avg({<Z1V1niO={'>(=replace($([UG_GH]),'.',','))'}>*<Z1V1niO={'<(=replace($([OG_GH]),'.',','))'}>}[Z1V1niO])
regards,
MT