for Label of MR
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.