Conditional Formatting on LISS

Dominika_Dudzinska

Hello,

I created a module that has a lot of line items and corresponding values in 3 Versions (FCST, Budget, Variance).

I need to mark the Variance column in red when the Variance has minus value for a subsequent line items.

PS. Variance is part of LISS from source module

Can you please suggest me what I should do in this case?

Thanks

Accepted answers

Vinay VaradarajM

@Dominika_Dudzinska ,

Still you can follow the same principle.

Each of the lineitems needing conditional formatting (which have different drivers) will need a separate Conditional Formatting lineitem as shown:

Data view

Screenshot 2021-07-05 at 6.25.29 PM.png

Blueprint view

Screenshot 2021-07-05 at 6.26.19 PM.png

Regards,

vinayvm

All comments

Vinay VaradarajM

@Dominika_Dudzinska ,

You could achieve this by creating lineitems which you can use for conditional formatting, as shown in the below example. Hope you can extend this to your case:

Data setup:

"Value" is the data lineitem which is formatted using the lineitem 'CF' (shown in another view below).

Screenshot 2021-07-05 at 4.16.57 PM.png

Blueprint view

Screenshot 2021-07-05 at 4.17.32 PM.png

Conditional formatting rule:

Screenshot 2021-07-05 at 4.17.16 PM.png

Regards,

vinayvm

Dominika_Dudzinska

Hello,

Thank you @Vinay VaradarajM for your reply, my case is little more complicated.

I need to have the attached line items because they have a different format (%, normal number) -see the following photo:

Sales, Mat.Exl.Freight, Memo:Freight... - line items

Forecast, BBP, Variance - Line Item Subset

Best regards,
Dominika

Vinay VaradarajM

@Dominika_Dudzinska ,

Still you can follow the same principle.

Each of the lineitems needing conditional formatting (which have different drivers) will need a separate Conditional Formatting lineitem as shown:

Data view

Screenshot 2021-07-05 at 6.25.29 PM.png

Blueprint view

Screenshot 2021-07-05 at 6.26.19 PM.png

Regards,

vinayvm

Dominika_Dudzinska

It works!

Thank you @Vinay VaradarajM for help.

Best regards,

Dominika

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…