Amount not seen during Zero Suppression

[appleglaze28]

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);

[Steve Vincent]

do you have any feeders for those statements?

[jim wood]

Makes sense. Over feeding would cause something like that.

[kpk]

Makes sense. Over feeding would cause something like that.

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

[kpk]

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.

[jim wood]

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.

[appleglaze28]

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

[kpk]

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