Forum Discussion

Brainscand's avatar
Brainscand
Frequent Visitor
9 years ago

separator in queries forcing ( ) around numbers

Hello,

 

Please can anoyone advise what this could be ?  Issue: when typing a statment E.G   this is how i normally would type this formula  : IF(Sales[Order Date]=TODAY(),1,2) But some setting has changed and its forced me to add  () to all my values ?? EG  IF(Sales[Order Date]=TODAY(),(1),(2)) otherwise it doesnt pick up the , seperator in the querery. Im sure it is sommething simple that im going to kick myslef for. But i have tried everything, resetting regional settings reinstalling PB. Nothing same issue. 

 

 

1 Reply

  • Brainscand's avatar
    Brainscand
    Frequent Visitor
    9 years ago

    Okay found the issue it is in regional settings "Digit Grouping was blank and should be  ,