Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi experts
sum(x)=10
sum(y)=20
i need to display 10:20 as 1:2 in straight table
how can i achieve with expression
thanks in Advancd
It would be useful, to help better, to know what's the use for...
anyway, try:
'1:'&sum(y)/sum(x)
in your example, you get an inter ratio, with 1 as numerator
perhaps you need a solution for more complex values (i.e.: sum(x)=35,8 and sum(y)=0,23): wath would you expect to see in this cases ?