Issue in sorting

[#1]

Hi,

Need some guidance to deal with this requirement in straight table.

I want all the schedules in red on the top. And I have given following expression for background colour.

if([Prior Month End Original Term] <> [Month End Original Term] or

    [Prior Month End Commencement Date] <> [Month End Commencement Date] or

    [Prior Month End Maturity Date] <> [Month End Maturity Date] or

    [Prior Month End Interim Rent] <> [Month End Interim Rent] or

    [Prior Month End Accrual Code] <> [Month End Accrual Code] or

    [Prior Month End Lessor Yield] <> [Month End Lessor Yield] or

    [Prior Month End LeasePak Vendor Subsidy] <> [Month End Vendor Subsidy], rgb(255,0,0),null())

Can someone help me with this?

Thank you in advance.

Please find screenshot attached.

Regards,

Aditya

[MarcoWedel · Accepted solution]

sorting expression for schedules ascending:

[Prior Month End Original Term] <> [Month End Original Term] or

    [Prior Month End Commencement Date] <> [Month End Commencement Date] or

    [Prior Month End Maturity Date] <> [Month End Maturity Date] or

    [Prior Month End Interim Rent] <> [Month End Interim Rent] or

    [Prior Month End Accrual Code] <> [Month End Accrual Code] or

    [Prior Month End Lessor Yield] <> [Month End Lessor Yield] or

    [Prior Month End LeasePak Vendor Subsidy] <> [Month End Vendor Subsidy]

Hope this helps

regards

Marco

[#3]

Thank you Marco

[petter]

Your color expression could also be used as an expression to sort on because the expression will evaluate to -1 or 0.

-1 will come on top if you sort ascending and 0 after the -1...

So:

([Prior Month End Original Term] <> [Month End Original Term] or
[Prior Month End Commencement Date] <> [Month End Commencement Date] or
[Prior Month End Maturity Date] <> [Month End Maturity Date] or
[Prior Month End Interim Rent] <> [Month End Interim Rent] or
[Prior Month End Accrual Code] <> [Month End Accrual Code] or
[Prior Month End Lessor Yield] <> [Month End Lessor Yield] or
[Prior Month End LeasePak Vendor Subsidy] <> [Month End Vendor Subsidy])

Could be put in as an expression in the sort tab for your chart - make sure to select a column that is right for it and then check for Expression in Sort by. Make sure that you put the priority right by Promoting the column to the top...

[petter]

a bit too slow and late me I mean...

[#6]

Thanks, I appreciate your help Petter.