Confirmation Rule to check for nodata vs 0

[mgreenberg]

I need to be able to write a confirmation rule that checks for nodata vs a value of zero.   Can someone help with the syntax

I have this - 

Dim cellstatus As DataCellStatus = api.Data.GetDataCell("Cb#CimpressConsol:P#TotCimpress:C#Local:S#Actual:V#YTD:A#BS_NoMap:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#None:U8#None").cellstatus

but I dont know how to build the If to check on the result.

[Big_Rick_CPM · Accepted solution]

The cellStatus property has several Boolean properties/methods you can call to determine the status. I would do something such as the following:

The below shows all the available Boolean properties you can use from a DataCell cell status:

[mgreenberg]

Thanks!  This is perfect.   Can I ask where you get this information on how to do this?   I was not able to find anything in the OS documentation or even in the OS books.

[Big_Rick_CPM]

Some of the guides, such as the 'Design and Reference Guide' or 'OneStream Finance Rules and Calculations Handbook' mention cell status properties for either a data cell or data buffer cell, but they do not explicitly show examples like you mention. For me, I find scrolling through the IntelliSense window in the OS IDE to be the easiest approach for finding methods to use.