TM1 Forum

Posted: **Thu Nov 12, 2009 5:39 am**

I'd like to ask why values dervied using IF statement where the value being compared is a string?

This is the rules I got for the IF statement:

Code: Select all

['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='1st 8 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '1st 8 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='9 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '9 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='10 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '10 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='11 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '11 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='12 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '12 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='13 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '13 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='14 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '14 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='15 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '15 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='16 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '16 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='17 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '17 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='18 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '18 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='19 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '19 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='20 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '20 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='21 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '20 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='22 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '20 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='23 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '20 Hours', 'Actual Rate'), continue);
['Amount' ] = N: IF (DB('plan_manpower_cost', !base_day_month, !base_year, !base_version, !base_service_type, 'Hours Status')@='24 Hours',DB('staging_sevice_hour_type_rate', !base_day_month, !base_year, !base_version, !base_service_type, '20 Hours', 'Actual Rate'), continue);

Posted: **Fri Nov 13, 2009 10:08 am**

do you have any feeders for those statements?

Posted: **Fri Nov 13, 2009 12:24 pm**

Makes sense. Over feeding would cause something like that.

Posted: **Fri Nov 13, 2009 12:48 pm**

jim wood wrote:Makes sense. Over feeding would cause something like that.

Over feeding does not cause this.
But under feeding (lack of necessary feeders).

Posted: **Fri Nov 13, 2009 1:05 pm**

This it a lack of feeder issue.
You can see it from the 'Amount' of January.
It is 0 on your screenshot and you have only N level rules for the Amount dimension element.

Posted: **Mon Nov 16, 2009 7:59 am**

kpk wrote:
jim wood wrote:Makes sense. Over feeding would cause something like that.
Over feeding does not cause this.
But under feeding (lack of necessary feeders).

Indeed thanks for the correction. I mis-read the question. A school boy error on my part, still we all make em.

Posted: **Tue Nov 17, 2009 8:09 am**

I'm still not too familiar how feeder regarding IF statement is written especially that the IF statement result is a String

Posted: **Tue Nov 17, 2009 8:35 am**

IF does not matter.
Try the following statement:
['Number of employee']=>['Amount'],['TOTAL COST'];
This Feeder statement tells TM1 to calculate ['Amount'] and ['TOTAL COST'] measures when ['Number of employee'] is not 0.
Regards,
Peter

TM1 Forum

Amount not seen during Zero Suppression

Amount not seen during Zero Suppression

Re: Amount not seen during Zero Suppression

Re: Amount not seen during Zero Suppression

Re: Amount not seen during Zero Suppression

Re: Amount not seen during Zero Suppression

Re: Amount not seen during Zero Suppression

Re: Amount not seen during Zero Suppression

Re: Amount not seen during Zero Suppression