Conditional formatting on LISS based on Collect() line item value

Hi,

I have a financial reporting module with only one line item, Collect, which as the name suggests is collecting values from a LISS with the Collect() function. The LISS is a fake versions list that has actual, budget and actual vs. budget as list members. I now want to do conditional formatting to the "Actual vs. Budget" LISS list member so if the actual is below budget the numbers are red. I understand how you normally format line items but since I now want to format a specific list item based on the collect I'm not sure how to get this done since any rule I create for the Collect() line item will impact all list items.

Best regards,

Johan

Accepted answers

Akhtar.shahbaz

Hi @johan.marketoft ,

Make sure when you want to apply conditional formatting on custom View then line item must be either in row or column then only you can apply CF, You can't apply CF if you keep line item on page selector.

Once you applied the CF then you can move your line item to Page selector, it will work

Hope this helps!

Thanks

Akhtar

All comments

nathan_rudman

you cannot do that.

I very often use line items for version comparisons.

JLD

Hi @johan.marketoft ,

For now, formatting the font itself is not yet available. But we can do format the background color of the cells.

As for your requirements, you can try creating a new line item (number format) applying the same LIS as dimension. Input your condition resulting to number (for eg. if actual lines < bgt lines then 1 else 0). Then use the new line as your conditional format base (eg. if the value is 1 then use the red bg).

Hope this helps or gives you idea on how to do it using your LIS.

Regards,

Jud

johan.marketoft

Hi @JLD ,

I have successfully created the CF line item to conditional format based on 0 and 1 but cannot get this to the New UX without creating a Saved View which then blocks my filters... and I cannot seem to create the CF directly in the New UX based on my pivoting:

Column: Time, LISS

Line item: Collect, CF

Best regards,

Johan

Akhtar.shahbaz

Hi @johan.marketoft ,

I have tried to replicate your requirement. Attached the screenshot for your reference.

LIS Module:

CF formula:

NUX Conditional Formatting:

Hope this helps!

Thanks

johan.marketoft

Hi @Akhtar.shahbaz , thanks for showing the formula works very well. However, how did you manage to get the CF to the New UX? When I create the grid card from Custom View it doesn't allow me to decide on CF, and if I select a Saved View I will not be able to do the filtering that I'd like.

Best regards,

Johan

Akhtar.shahbaz

Hi @johan.marketoft ,

Once you applied the CF then you can move your line item to Page selector, it will work

Hope this helps!

Thanks

Akhtar

johan.marketoft

@Akhtar.shahbaz ,

Thanks this initially worked but I'm now having issues. As I have fake versions also in the column I only want to CF the variances (ex. Actual vs. Budget, Forecast vs. Budget etc.) and not the single versions (Actuals, Budget, Forecast). Even though I only select the line items under the variance versions and try to submit CF for only them it goes for all anyways... Do you know how to resolve this?

Best regards,

Johan

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…