Forum Discussion
IF Number Ends With
I have a number field with different data: 1.00 1.14 2.00 1.01 I want to write a formula that states if the number ends with .00 then "Parent", if not then "Child" My formula below is ...
- How about this instead:
Parent =
IF ( 'DataReader vSalesMaster'[SalesOrderLine] = TRUNC( 'DataReader vSalesMaster'[SalesOrderLine]), "Parent", "Child") Hi,
Try this calculated column formula
=IF(MOD('DataReader vSalesMaster'[SalesOrderLine],1)=0,"Parent", "Child")
Both solutions work great! Thank you so much!
You are welcome.