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