Forum Discussion

Castellum812's avatar
Castellum812
Brass Contributor
Mar 03, 2022

Power Query Validate Calculations

HI there,   I have an input sheet containing data from a CRM For a report I want to calculate remainig hours. For this I use two entrys / Numbers in tha data sheet. A / B  = C   There can be a ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 03, 2022

Castellum812 

You may add custom column like

=if A <= 0 or B = 0
 then C = 0
 else Number.Abs(A/B)
  • Castellum812's avatar
    Castellum812
    Brass Contributor
    Mar 04, 2022

    SergeiBaklan 

     

    Thanks

    Tht solved most of my questions

     

    But the one below somehow does not work.

    Dont understand why,

     

    if Duration.Days ([End date]- DateTime.Date(DateTime.LocalNow()) > 0 then Number.Round(Duration.Days ([End date]- DateTime.Date(DateTime.LocalNow()))/30.4) else 0

    The error it gives is "Token comma expected." Pointing at the "Number.Round" formula.

    If I leave out the "If's" the function works fine.

    Number.Round(Duration.Days ([End date]- DateTime.Date(DateTime.LocalNow()))/30.4)

    Must be a syntax thing but I have not been able to pin point it 😞

     

     

     

     

     

     

     

Resources