Issue with calculating the counts for active Global Assignment (GA) employees in the Story report

[Aji_Kottayil]

Spoiler

Hi People Analytics Story Report Experts,

We are currently encountering an issue with calculating the counts for active Global Assignment (GA) employees in the Story report. The problem arises particularly when dealing with the Current Date field in the calculation process. Could you please advise on how we can rectify this error

Code:

IF(ISNULL([Employment#Global Assignment Details#Actual End Date] ) ,"Active" ,IF([Employment#Global Assignment Details#Actual End Date] >=CURRENTDATE(),"Active" ,"Terminated" ) )

[LissieDomingo03]

The IFISNULL formula is not working. There is a blog post here (I forgot the link) where a workaround was introduced. Instead of ISIFNULL, do a CONCAT.

[LissieDomingo03]

The IFNULL is not working, you'll keep getting an error. There is a blog post here (I forgot the link) where a workaround was suggested. Instead of using IFNULL, do a CONCAT. 

CONCAT ([Employment#Global Assignment Details#Actual End Date], "!")

Any cell that returns only "!" is null/blank. You might need to convert the date string to a text though because the second parameter ("!") is read as a text and the first is read as a date.

[LissieDomingo03]

But also, why not use Home/Host Designation as filter.

[LissieDomingo03]

However, I would pull active Global Assignments by Home/Host Designation = Host, Employee Status = Active