Round Function does not work

[Daniel1908]

Hello together, 

I am using the below formula, unfortunately the round function does not work. 

=Count({<Price={0},[ReturnLabel.]={"R*"},[Key]-={2578}>}
If(round(Price,0.01)<round([Price1],0.01),Material,null()))

Price is loaded in the script as below:

if(floor("Price1")-(floor("Price3"+"Price4"))=0,'1','0') as Price

Thanks for your help. 
Kind Regards
Daniel

[Daniel1908]

That worked, thank you very much for your help. 

Kind Regards, 
Daniel

[Daniel1908]

Hi,

I added Num("Price",'#.##0,00'), to the script, but the price is still shown as below. 

 How do I get 1.998,25€?

Kind Regards,
Daniel

[rubenmarin]

Maybe column format is overwriting field format. Or just apply he same to the column or in the object itself.

What is that? a KPI, a table cell?

[Daniel1908]

I added Num("Price",'#.##0,00') into the column. 

This works fine. 

Thanks for your help. 

Kind Regards, 
Daniel