How to use "round" in a custom experssion

I have two columns A and B. I want to create column C which is A*100/B. My custom summary expression for this is Sum([A])*100/Sum([B]). This gives me a float value for Column C

I want to use C in a Gauge, so I want this to be a number (integer). I am unable to figure out how to do this. I thought this will be as Simple as round([C]) or round( Sum([A])*100/Sum([B]). ), but they both give expression errors.

Any pointers are greatly appreciated

Hi @akrishnamo
The Custom Expression problem with including functions within round() is fixed in the upcoming version 0.39.0, but until then as a workaround you can define the amount of decimals shown to zero:

1 Like