How to change String to Numeric ? Argument is not a numeric value.

[Testicuser123]

Hello,
I have a little problem with calculated function with one of my items.

Pooled oid:



Calculated item:


Right after testing this fomula I get response that it's not a numeric value:


But it looks like it is:


Any idea how to solve this problem?

How can i change this value from string to Numeric?

[Bartosz Mickiewicz]

Hi,
Can you show preprocessing steps?
You could use JavaScript and put in "return parseInt(value)" and then test and see if it works.

[Testicuser123]

Hi,
Can you show preprocessing steps?
You could use JavaScript and put in "return parseInt(value)" and then test and see if it works.

Hi, thanks for your reply. I don't have anything in preprocess. I've tried to use that and the value on currentusagepowervaluetest showed correct value:

but...
1kwh item still not working as I want:

[cyber]

That syntax doesn't add up...
function(/host/key,<parameter1>,<parameter2>,...)

so if iti is directly on host it should be "avg(/hostname/currentusagepowervaluetest,3600)/1000" I think. Skip hostname, if added through template."avg(//currentusagepowervaluetest,3600)/1000"

[Testicuser123]

That syntax doesn't add up...
function(/host/key,<parameter1>,<parameter2>,...)

so if iti is directly on host it should be "avg(/hostname/currentusagepowervaluetest,3600)/1000" I think. Skip hostname, if added through template."avg(//currentusagepowervaluetest,3600)/1000"

I've found this solution on reddit first link in google : Monitoring Power usage with Zabbix and Grafana


After applying your configuration to my template :



I've got this error:

But, there is a item called currentusagepowervaluetest.



Any idea?

Thanks in advance

[cyber]

You are pressing "Test" when you are editing template.. it cannot go and pull data, ... Go to the host directly, find that calculated item and try there (click on item, so it opens and find test there) ... you should get the value from host directly.

[Testicuser123]

You are pressing "Test" when you are editing template.. it cannot go and pull data, ... Go to the host directly, find that calculated item and try there (click on item, so it opens and find test there) ... you should get the value from host directly.

Oh my... You're the boss! Huge thanks to you