Hi team,
There is one Numbered List(Site List) and a Line Item(WFC).
And we need a Chart(Dot Chart) with WFC >6 and WFC <6 in different colors.
Can you please help me on this.
Thanks
@saurav4ss
Conditional formatting in the UX uses a line item number reference to determine what colour to use.
Therefore, create a new line item in your target module and using IF THEN ELSE create a condition in which a +1 is returned when WFC > 6 and a -1 is returned when WFC < 1.
I would also caution as to what happens when WCA = 1.
Therefore, use a statements similar to the following;
= IF WCA > 6 THEN 1 ELSE IF WCA < 6 THEN -1 ELSE 0
Zero is return if neither conditions are met.
In the UX when setting up the dot chart use this line item to inform the conditional formatting.
Good luck,
Chris
Hi everyone, I'm building an Actual vs. Budget P&L reporting module in Anaplan using a Line Item Subset (LIS) to display the P&L items. I would like to extend my report to include three additional columns under a "% of Revenue" section: Act % = Actual amount / Actual Revenue Bud % = Budget amount / Budget Revenue % Var =…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
