How to update cell values based on different criteria

Dear all,

First of all, thank you all for all the support you provide here. It has been very useful in my training journey.

Now I am working on a report where I have to put data based on % value, so the total % is in a line item and in new line item, I am trying to rank it based on %. I am trying below formula, but it seems not working.

IF Cumulative QTY <=70% THEN "A" ELSE IF Cumulative QTY >70% AND Cumulative QTY < 90% THEN "B" ELSE "C"

Any help and pointers are highly appreciated.

Thank you,

Sabita

Accepted answers

All comments

anikdas

Hi @Sabita

The formula looks to be fine at face value and should work. Can you please share the details of the module that you are trying to do this and what error you are facing?

Sabita

Thank you anikdas, for looking into this.

Yes, formula was fine and it worked.

The issue was that I was using % it should be only numeric values.

Kind Regards,

Sabita

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…