Forum Discussion

An's avatar
An
Regular Visitor
5 years ago
Solved

ISSUE :  Format fields in the matrix visual based on the blank values.

ISSUE :  Format fields in the matrix visual based on the blank values.   I want to format the fields of matrix visual to RED when, the current month's value is BLANK and previous month's value is N...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    See attached - this becomes much more complex as you cannot provide computed conditional formatting to something that isn't there,

An's avatar
An
Regular Visitor
5 years ago

Hi, 

 

This is the input table :

 

VendorPeriodActual 2020Comment
MSFT1100XXXX
MSFT2200XXXX
MSFT4300XXXX
PXS2100XXXX
PXS4100XXXX
TEL3100XXXX

 

Expected outcome :

 

 1234TOTAL
MSFT100200

- 

300600
PXS- 100- 100200
TEL  100- 100

 

I can't added a pbx.file to this message.   I hope this clarifies my question.

 

Thanks for your help 

 

An