Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    8 years ago
    How about this instead:
    Parent =
    IF ( 'DataReader vSalesMaster'[SalesOrderLine] = TRUNC( 'DataReader vSalesMaster'[SalesOrderLine]), "Parent", "Child")
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this calculated column formula

     

    =IF(MOD('DataReader vSalesMaster'[SalesOrderLine],1)=0,"Parent", "Child")

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
8 years ago
How about this instead:
Parent =
IF ( 'DataReader vSalesMaster'[SalesOrderLine] = TRUNC( 'DataReader vSalesMaster'[SalesOrderLine]), "Parent", "Child")