0

Trying to achieve the PanelSoldMonths rate using PanelSoldDays and DateDaysInMonth. However, I am getting a return of nulls when doing this simple division.

PanelSoldMonths = PanelSoldDays / DateDaysInMonth

WITH MEMBER [Measures].PanelSoldMonths AS 
IIF ([In Charge Date].[In Charge Date Days in Month]= 0, NULL,
     ([Measures].[Panel Sold Days] / [In Charge Date].[In Charge Date Days in Month].Children))
    SELECT 
    {[Measures].[Total Net Net Revenue], [Measures].[Panel Sold Days], [Measures].PanelSoldMonths}
ON COLUMNS, 
NON EMPTY
    ([In Charge Date].[In Charge Year].Children,  [In Charge Date].[In Charge Date Days in Month].Children)
ON ROWS
    FROM [Combined Sales]
    WHERE [Asset Info].[Format Group L2].&[Digital]

enter image description here

MoazRub
  • 2,881
  • 2
  • 10
  • 20
Shoaib Maroof
  • 369
  • 1
  • 3
  • 13

1 Answers1

1

Replace

[In Charge Date].[In Charge Date Days in Month]= 0

with

[In Charge Date].[In Charge Date Days in Month].currentmember.Properties ("Member_Value",TYPED)=0
MoazRub
  • 2,881
  • 2
  • 10
  • 20