Hi,
I'm sure I'm having a blond moment. What's the easiest way to achieve the equivalent of this Excel formula/situation (Column F), in Anaplan ?
Thanks!
Better to split formula in two line items:
"Promo mentioned" = NAME(Promo copied from[FIRSTNONBLANK:Promo copied from])
"Value" = IF ISBLANK(Promo mentioned) then "not used" else Promo mentioned
Hi @Alessio_Pagliano
FIRSTNONBLANK must work. If isblank(Promo copied from[FIRSTNONBLANK:Promo copied from]) then "not used" else name(Promo copied from[FIRSTNONBLANK:Promo copied from])
Super! Thanks a lot @KirillKuznetsov , much appreciated!
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
