Skip to Content
Former Member
Aug 02, 2012 at 01:01 AM

Calculated_Column Expression not functioning properly



I am using a calculated_colum action block to insert two columns "PercentUtilized" and "PercentFree" in the XML.

In Configure Object, I ahve selected document source. I have defined two columns as Double in "Defined Columns".

For PercentUtilized, I am writing following expression which is not working:

stringif( DrilldownDepth == "1", (100 * TotalTime) / (datediffminutes(#Transaction.StartDate# , #Transaction.EndDate# )) , (100 * TotalTime) / (24*60*30) )

DrilldownDepth and TotalTime both are coming from Source XML of Calculated_Column.

After execution, this action block adds two column PercentUtilized and PercentFree in the XML but its value comes as NA.

Can anyone plz help why is this not working?