for Label of MR

Jsdeloria21

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,

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!

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,