I'm trying to calculate a % value based on the CoS of tariffs

The calculation needs to work on the CoS values in the below, so trying to compute the Blank Tariff CoS value as a % of the Relevant Tariff CoS, so for example - 244,024/14,878,715 = 1.64%

Accepted answers

devrathahuja

@kmht0307 -

Hope this helps :)

SYS Module

Calculation Module

I've used select for a quick showcase but you should use lookup instead in this case.

If you also want to present these values in a dashboard then calculate the % line item as x100 and then format it in the NUX as % for that line item & tariff combination.

All comments

devrathahuja

@kmht0307 - Create another line item called final to calculate the relevant value.

Final = IF Relevant Traffic then Source else "calculation" where your calculation will have the logic you mentioned.

kmht0307

I am not sure that this will work as Relevant Tariff is not a recognised line item

devrathahuja

@kmht0307 - You will need to create a SYS Module where you identify using a boolean the relevant traffic member.

Similarly, for the calculation logic you will need to apply a lookup that can be placed in a Lookup Module.

kmht0307

Not sure that I understand the solution

devrathahuja

@kmht0307 -

Hope this helps :)

SYS Module

Calculation Module

kmht0307

I get this now, but I can see this error:

I don't get this error if I use SELECT instead of LOOKUP.

devrathahuja

@kmht0307 - You should place this lookup in a SYS Lookup module and refer to that line item here.

Quick Links

Can you help?

Unanswered questions

Anaplan Level 3 User Story 1.11
"Regarding User Story 1.11: Should the module dimensionality be restricted to the Account level, or is it a requirement to include the Product grain as well?"
export and filter button
Hello, I have a table displayed on a UX page, and I would like to add an export button that allows users to export the data exactly as shown in the table. Ideally, the export should reflect: applied filters sorting any user selections or context Is there a way to export data dynamically from a UX table so that it matches…
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.…