Return blank value using IF () in story report

[RishabhGupta19881]

Hello Experts,

We have a requirement to populate a field value as below in story reports:

If Field Value matches to particular value, then Return "Last Modified Date Time" else Return Blank.

I tried to achieve it using IF () Function, but system is expecting second parameter of IF () Function also as Date Time type value, not blank. 

Any assistance would be really helpful.

[SWegiel · Accepted solution]

The problem is that both sides of the If statement have to be the same type of value e.g. both Text.  One solution for this is to create a separate calculation that converts the Last Modified Date to a Text.  

Convert the Last Modified Date to a Text field by creating this calculation:

CONCAT(

CONCAT(

CONCAT(

CONCAT(TOTEXT(MONTH([Employment#Job Information#Job Last Modified Date]))," / "),

TOTEXT(DAY([Employment#Job Information#Job Last Modified Date]))),

" / "),

TOTEXT(YEAR([Employment#Job Information#Job Last Modified Date])))

Then use this Calculation in your If statement:

IF([User#Basic User Information#Gender]="F" ,[LASTMODDATETEXT] ," " )

[N1kh1l]

@RishabhGupta19881 

May be try the else part as NULL

IF(Field Value=Somevalue,Last Modified Date Time,NULL)

Hope this helps !!

Nikhil

[RishabhGupta19881]

Hi Nikhil, system does not accept NULL, i tried that also 🙂

[N1kh1l]

Could you please show how your formula looks like

[N1kh1l]

I tried writing a similar formula and NULL loos fine here