Forum Discussion

OlaWidera's avatar
OlaWidera
New Contributor II
3 days ago

help with a conditional statement

Hello, I wrote a simple formula for Wip Rev that checks the amount in Earned Revenue (that is calculated too) and calculates the difference between its current value(POV)  and prior year end value(...
Admin
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
3 days ago

I would include a check for NoData in your if statement:

Dim JTDRevenueLoadedDataCell = api.Data.GetDataCell("A#REVENUE_EARNED:U8#None:O#Top:F#EndBal:V#YTD:T#POV") as DataCell
Dim JTDRevenueLoadedDataCellStatus = JTDRevenueLoadedDataCell.CellStatus as DataCellStatus
Dim JTDRevenueLoaded = JTDRevenueLoadedDataCell.CellAmount as Decimal

If api.Pov.Cube.Name.XFEqualsIgnoreCase("WIP_Cube") Then 'run for the WIP Cube

    If ((Not api.Entity.HasChildren()) OrElse api.Cons.IsForeignCurrencyForEntity()) Then 'Run for base entities and all Canadian Entities

        If (JTDRevenueLoadedDataCellStatus.IsNoData OrElse JTDRevenueLoaded = 0) Then 'if Earned Revenue is zero

 

  • OlaWidera's avatar
    OlaWidera
    New Contributor II
    2 days ago

    Hi Rob,

    Thank you for this suggestion. I implemented it but still didn't get the positive outcome. I technically should have data (zero) because I would enter data into a test, but to your point in real life we might have no data situation as well so will keep that part of the formula