How to make Condition % in One Data

[eddykwan_]

Hello I want to ask how to make GPM Value is % Without Data Sales until Net Profit not Percentage In Table Qliksense ?

Thank You 

[Mark_Little]

Hi,

Can you share the expressions you have and how the logic behind calculating GPM%?  

[eddykwan_]

For Calculating is Value Net Profit / Sales 

But in Data Excel is just the value only 

[MayilVahanan]

Hi

Try with Num() function in expression for individual instead of using default formatting option. 

[udit_k]

Follow below link for row level formatting in table

Row Level Formatting in Qlik Sense - Qlik Community - 1835627