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%
@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.
@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.
I am not sure that this will work as Relevant Tariff is not a recognised line item
@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.
Not sure that I understand the solution
I get this now, but I can see this error:
I don't get this error if I use SELECT instead of LOOKUP.
@kmht0307 - You should place this lookup in a SYS Lookup module and refer to that line item here.
Summary: Workflow does not display detailed error messages and marks success despite partial failures. Impact: Developers and workflow users will be receiving false-positives due to the “Completed Message” despite partial failures, that are present when manually triggering processes and through cloudworks. The expectation…
We have a business requirement of calculating running IRR to calculate the performance fee. Currently, Anaplan IRR function gives 1 final output basis entire cashflow We need running IRR to start calculating the performance fee from the period if the IRR exceeds Hurdle rate This is a highest priority item and needs to get…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
