Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change the values in measure as percentage?

Hello All,

12.png

From the above graph

In delivered emails i have values but in open rate i need those values should be in percentage type as well as in signup rate too.

13 Replies
OmarBenSalem

OR not AND , a TYPE can't be OPEN and SIGN UP at the same time; or would work :

Not applicable
Author

No it's not working for both, can u send me formula

OmarBenSalem

It's working for me  :

Type='SIGN-UP' or Type='OPEN'


not

Type='SIGN-UP' or 'OPEN'


if(Type='SIGN-UP' or Type='OPEN' ,num(sum(Sum),'##0,00'), num((sum(Sum)/sum(total Sum))*100,'##0,00%'))

Capture.PNG

Not applicable
Author

Sorry it was my mistake,it's working fine,,,,thank u so much