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?