1 Reply Latest reply on Aug 24, 2018 6:33 AM by Ankit Bansal

    ZN is being called with (float, integer), did you mean (float)?

    Jane Wu

      1) [Fee Amount] Calculated Field: SUM(ZN([Workfile Amount],0))+SUM(ZN([Billed Amount],0)) I have red highlight around ZN with ZN is being called with (float, integer), did you mean (float)?

      I want to add the two fileds [Workfile Amount] and [Billed Amount] together, right now some of the entries in either fields are Null.

       

      from access the correct way to fix null is ZN( [Field], 0)

       

      Is this the correct way to resolve my issues in tableau?

       

      2) I wish to you the above calculation in an IF Function.

       

      IF

      DATEDIFF('month',DATETRUNC('month',[Work Date]),

      {MAX(DATETRUNC('month',[Work Date]))})=0 AND [Revenue Type]='Fee'

      THEN [Fee Amount]

      END

       

      [Fee Amount] would be an aggregated field. It doesn't seem to work with the IF function. What should I do to make it work?