6 Replies Latest reply: Sep 25, 2016 9:45 AM by Yeo Poh sai

# How to Flag my debt vs sales Table base on 3 condition ?

Hi All

Many people have help me create the Debt Vs Sales Table using the below link :-

Now I need add one mor column Flag each row base on below condition :-

1) If  sales = 0  Flag as Very High risk

2) If Debt > Sales Flag as High risk

3) if sales > Debt Flag as Low risk

So user is able to view the customer belong to which risk classification.

Paul

my qvw

• ###### Re: How to Flag my debt vs sales Table base on 3 condition ?

May be this:

If(Column(1) > 0, If(Column(2) = 0, 'Very High Risk',

If(Column(1) > Column(2), 'High Risk', 'Low Risk')))

• ###### Re: How to Flag my debt vs sales Table base on 3 condition ?

Hi Sunny

Thank you , it work.

PAul

• ###### Re: How to Flag my debt vs sales Table base on 3 condition ?

Hi Sunny

One more quick question, may I know how to make

Very High Risk text Color red Color .

High Risk text Color organ Color .

Low risk text Colour Green Color.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

• ###### Re: How to Flag my debt vs sales Table base on 3 condition ?

May be use an if statement for the background color of your new expression (you can also use Pick Match combination)

If(Column(4) = 'Very High Risk', Red(),

If(Column(4) = 'High Risk', ....., .....))

• ###### Re: How to Flag my debt vs sales Table base on 3 condition ?

Hi Sunny

Thank it work.

Paul