for Label of MR

Hi Community,

I need a little help on this module, we will use the line item here as a label on the MR report we are building. Particularly the line item (vs Budget(M Narrative – the column beside vs Budget (M) – Morse) . Basically what I need to be done is that in the Budget Morse column (IF vs Budget (M) Narrative is UP then Budget Morse column should be 1 else if Down then its 0. But for some reason it is showing large numbers instead of just 1 and 0 only. It will be use for the conditional formatting morse in the MR report.

Apologies for the lack of screenshot I dont have an access to the model anymore.

Hope you can assist.

Regards,

Accepted answers

BrunoRodriguez

Hello @Jsdeloria21,

It happens to all of us. I believe that they are changing the summary from SUM to NONE by default soon. That will force us to be mindful about them.

Cheers!

All comments

BrunoRodriguez

Hello @Jsdeloria21,

Can I assume that the formula used is:

IF LINE ITEM = "Up" then 1 else 0 ?

Cheers!

Jsdeloria21

hi @BrunoRodriguez ,

I did that on the Budget Morse line item. I even put text(Source Line item) IF text(Source Line item) = 1 then 0 but for some reason it shows larger number rather than 1 or 0. which i find weird. My apologies for not showing the Blue print view. I dont have access to the model anymore. I am actually working on the training model.

Regards,

BrunoRodriguez

Hello @Jsdeloria21 ,

No worries about the model.

If the format of the line item was text, you would not need the TEXT() on it. However, you would need the "Up" to compare it.

Ok, I believe what happened. It worked at the lowest granularity. However, you have 3 lists and time in the module, which means that once you go to the top level - if the summary is SUM - it will autoaggregate. Hence, the issue is the summary method. Either set it up as None or Average and it should work.

Cheers!

Jsdeloria21

hi @BrunoRodriguez ,

Appreciate the feedback. Summary method is always giving me problems. I keep forgetting to turn it off and keep it on SUM all the time. I think that is the problem. thanks for providing some feedback here.

Regards,

BrunoRodriguez

Hello @Jsdeloria21,

It happens to all of us. I believe that they are changing the summary from SUM to NONE by default soon. That will force us to be mindful about them.

Cheers!

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…