Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to see the all values of Summary_Status except Cancelled and Rejected.
Please help me to understand why this line of code doesn't work for me:
=if(Summary_Status <> 'Cancelled' or Summary_Status <> 'Rejected', Summary_Status)
=if(Not wildmatch(Summary_Status,'Cancelled','Rejected'), Summary_Status)
As you said ... except Cancelled and Rejected
=if(Summary_Status <> 'Cancelled' and Summary_Status <> 'Rejected', Summary_Status)
try,
count({<Summary_Status-={'Cancelled','Rejected'}>}Summary_Status)
Regards,
instant of your if expression used below expression
=if(wildmatch(Summary_Status,'*Cancelled*','*Rejected*')=0, Summary_Status)
Because sometime space remains with your string value so, first you have to trim your sting or remove space like below:
=if(trim(Summary_Status) <> 'Cancelled' or Trim(Summary_Status)<> 'Rejected', Summary_Status)
I hope this will help you.
Regards
Ahmar
try this:
If(Not(Match(Summary_Status,'Cancelled','Rejected')),Summary_Status)
=sum({$<Summary_Status-={'Cancelled','Rejected'}>}Sales)
=sum({$<Summary_Status-={'Cancelled','Rejected'}>}Field)
Check this:
=if(Not wildmatch(Summary_Status,'Cancelled','Rejected'), Summary_Status)
=if(Not wildmatch(Summary_Status,'Cancelled','Rejected'), Summary_Status)
Not equal to operator is not working as expected . Any help?
$value <>'26' AND $value <>'32'