Hi , currently in my reports, i have 3 types of columns.
1. sales 989999
2.sales % 98
3.count 400000

here i need to get the values as
if the value is <999999 then it should be like 9999.99, if it is >999999 it should be same.
so what could be the expression for this?