Actuals

[lcapon]

Hi,

Please could you help me understand which setting i have incorrectly which is populating my actuals in advance in image 1? Image 2 is correct.

[lcapon]

FTE - IF Current Employee THEN 'ES005 Employee Details'.FTE ELSE 0

Mat Leave - IF 'ES005 Employee Details'.'Maternity/Long Term Sick Start' <= END() AND 'ES005 Employee Details'.'Maternity/Long Term Sick End' >= START() THEN 'ES005 Employee Details'.FTE ELSE 0

Head Count - IF Current Employee THEN 1 ELSE 0

Mat Leave Head Count - IF 'ES005 Employee Details'.'Maternity/Long Term Sick Start' <= END() AND 'ES005 Employee Details'.'Maternity/Long Term Sick End' >= START() THEN 1 ELSE 0

Vehicle Allocation - IF 'ES005 Employee Details'.'Car/Van Allocation' THEN 1 * Head Count ELSE 0

[Misbah]

@lcapon

Which specific line item were you looking at when you posted the query?