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