Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you Marco
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...
a bit too slow and late me I mean...
Thanks, I appreciate your help Petter.