TM1 Forum

Hi there

I have a fairly simple string calc - ie checks numeric measure, and if the value <> 0, then set string to 'y'.
I feed the string value with the numeric value, and th numeric value is pucnhed in (so no feeder issues here).
I use the feedstrings statement as well, but when I click suppress zeroes, everything disappears.

Please check out code below.
Any ideas?

Many thanks
Chris

Feedstrings;
Skipcheck;

['ProfR - FlagS'] = s:if(DB('Profitability - Allocation Flags',!Customer - ProfR High Level,!Product - ProfR High Level,!Reporting Heirarchy - High Level,'ProfR - Flag') <> 0, 'y',Continue);

Feeders;
['ProfR - Flag'] => DB('Profitability - Allocation Flags',!Customer - ProfR High Level,!Product - ProfR High Level,!Reporting Heirarchy - High Level,'ProfR - FlagS');

Hi there,

I am not too sure why you would need to feed this rule, as it is just a 'Y' value. It does not come from anywhere inside TM1, so I do not see how you could feed it.

Is it part of a Consolidation?

Thanks. Trevor.

Hi

Situation is this:
Users will navigate up and down the product/customer hierarchy and flag items which need to form part of a calculation.
Originally, I had some string calcs where if parent is flagged, then child gets flagged. Think of web page and selecting items in a hierarchy - you tick the parent item, and the children automatically get flagged. So my Tm1 calc was along the lines of - if parent = 'y' then 'y' else continue. This allows users to select at any point in the hierarchy.

Problem kicks in with feeders. Fortunately, I can feed from actual values, since selections will only be relevant where there are actuals.
But I have been having problems with any form of string feeding. In this case, am I just setting up a basic example to test string feeding, and cannnot get it to work. Basically I need to feed the strings, else my calcs which reference them do not seem to work, and values disappear when zero supress on.

Regards
Chris

Hello again,

It must be the Feeder that is aiming to the String based rule, becuase string cells can be fed, when the syntax and logic is sound.

Have you considered not including FEEDSTRINGS in your rule file? This will eliminate the feeding of string values and depending on how many cells you have that contain strings, may be the better option.

you can print out the new Rules/Feeders in here if you like.

Thanks.

Trevor.